Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate and negative Recno()
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00734486
Message ID:
00734495
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Hi Pedro,
This is because in a buffered table records appended have negative recno(), after tableupdate command they are "committed" and phisically added to the table and got positive record number, so nrecno variable store a record number which doesn't exist anymore (and give you the error).
take a look at "Buffering Data" in docs

HTH

>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