Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
In negative territory...
Message
From
20/06/2006 10:53:01
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
20/06/2006 10:33:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01130247
Message ID:
01130250
Views:
12
Asuming you have table buffering (so you can have more than one record with pending changes), if you add records, the first record will have recno = -1, the second record you add will have recno = -2, etc. These are temporary numbers; once the record is saved, it gets the permanent recno, depending on its position in the table.

>Hi All:
>
>I'm using a local view in a grid and the last record, regardless of how many there are,
>always reports its recno() as -1. Then during a scan... endscan, no surprise, I get an
>'Out of range error' when it hits that record, the view locks up, the app crashes,
>but only intermittently. I have to kick it around a bit by adding
>and deleting records, but still...Does anybody know why?
>
>Thanks,
>Luke
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
Next
Reply
Map
View

Click here to load this message in the networking platform