Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate and negative Recno()
Message
From
19/12/2002 10:30:10
 
 
To
19/12/2002 10:21:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00734486
Message ID:
00734490
Views:
18
This message has been marked as the solution to the initial question of the thread.
Before you issue TableUpdate, the records are buffered and assigned negative record numbers. After you issue TableUpdate, they are physicially added to the table with positive record numbers, therefore all negative records are gone. If you want the record pointer to be on the same record, you should issue a SEEK or LOCATE to get back to the record, not RECNO().


>Hi
>
>i have buffer = 5
>I need make this :
>
>Select Tabela1
>nRecno = Recno()
>=TableUpdate(1,.T.)
>GO nRecno
>
>give me a error , nRecno is negative
>
>
>The help VFP says :
>
>RECNO( ) returns negative numbers for records appended in a table buffer.
>
>What this means ?
>
>I only want after TableUpdate , pointer stay in same record , that where before TableUpdate .
>
>Thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform