Normal Topic @formresultsettotal() issues (Read 2038 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
@formresultsettotal() issues
Apr 20th, 2010 at 6:04pm
Print Post Print Post  
This simple program, when used in a mass update, only gives correct results when 'interactively' updating records. When 'update all' is used in a mass update, the results show repeating numbers:

writeln(@formresultsetcurrentposition("inven"))

results:
1
2
3
4
5 etc.

when update all, I get:
1
1
1
1
1etc

Any thoughts?
  
Back to top
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: @formresultsettotal() issues
Reply #1 - Apr 20th, 2010 at 7:15pm
Print Post Print Post  
Hi Steve,
So far we have not been able to successfully reproduce what you are reporting. Can you provide us with some more details about you Mass Update programming?

Are you running the Mass Update on the main form or a subform?
Is the form name used in your programming targeting the main form or a subform?
Is there other programming in your Mass Update?
  
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: @formresultsettotal() issues
Reply #2 - Apr 20th, 2010 at 7:31pm
Print Post Print Post  
Ben,

No other programming in the mass update.
INVEN is the name of the main form, there are no subforms

odd that it works correctly when i use 'interactive update', but not when running 'update all'

This is a database that was translated from Q&A to ver 1.1.5, then upgraded to 2.5.1

Steve
  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: @formresultsettotal() issues
Reply #3 - Apr 20th, 2010 at 8:11pm
Print Post Print Post  
Just to confirm, I tested this on an old version 1 application that I had hanging around. Upgraded it with 2.5.1, and ran your code (modified for my form name).

It functioned perfectly every way I could think of -- interactive, starting interactive then going update all, and selecting continue when the dialogue box first comes up.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: @formresultsettotal() issues
Reply #4 - Apr 20th, 2010 at 8:16pm
Print Post Print Post  
It works fine in another application that I use, too....just not in my Inven database.
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: @formresultsettotal() issues
Reply #5 - Apr 20th, 2010 at 8:30pm
Print Post Print Post  
Hello Steve,

If you send in your Inven database with just a few records in it, we can run some tools on it here and see why @FormResultSetCurrentPosition() is not working correctly for you.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: @formresultsettotal() issues
Reply #6 - Apr 20th, 2010 at 8:35pm
Print Post Print Post  
Ray, will do.

Thanks,
Steve
  
Back to top
IP Logged