Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recno() returns -1 in buffered table.
Message
From
19/11/2001 10:09:34
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/11/2001 01:16:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00583329
Message ID:
00583421
Views:
31
>Hello All,
>
>Can anyone please help me to understand why the recno() command returns -1 in a buffered table. I am using pessimistic table buffering and it appears as though it doesn't matter how many records I add and commit with tableupdate(). Each time i append a blank record and do recno() it tells me the pointer is at
>-1. I understand that recno() will give negative numbers for buffered tables but I think it should change from -1 after the first record is added.

Newly appended records have negative numbers: -1, -2, -3, etc.

As soon as you TableUpdate() successfully, the records get their permanent record numbers assigned.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform