Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Go bottom
Message
From
11/10/2004 13:20:56
 
 
To
11/10/2004 04:35:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00950231
Message ID:
00950483
Views:
12
>hi,
>i put two commands at main form,to run two forms one to add new bills another to modify ,
>when i run add form it works,when i run modification form,and return to add form the counter is =1 not 9, but i have 9 bills at my table mstr .
>this is my code
>
>select 1&&mstr.dbf
>GO BOTTOM
>THISFORM.TEXT1.VALUE=BILLNO+1
>
>thanks .

Since EVERYBODY has told you about not selecting workareas by number rather than alias, I don't see any point in repeating that admonition.

Let's look at a couple of possibilities.

Somewhere in your code you have closed and opened MSTR in a different workarea and workarea 1 is not the table you are expecting it to be.

You have an index set so that GO BOTTOM gets you to a record where BILLNO has a value of 0

You have a filter set such that no records actually meet the filter's requirements. GO BOTTOM will therefore send you to EOF(). The values for any field when the table is at EOF() is (I believe) the default value for that field's datatype. For BILLNO that would be 0.

All the records have been deleted and SET DELETED is ON. GO BOTTOM will bring you to EOF().

Put a SET STEP ON just after you execute the GO BOTTOM statement, and from either the debugger or the command window, check to see which, if any, of the above conditions are true.
Previous
Reply
Map
View

Click here to load this message in the networking platform