Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Packing and RECNO()
Message
 
 
To
22/11/2002 10:40:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00725793
Message ID:
00725798
Views:
10
The record number is never permanent with respect to pack. It is just a sequential integer assigned to a row in the table based on its natural [non-indexed] position in the table. This is why you never depend on it for a PK or a FK reference in another table. Indexes have no affect on what the record number of a row is.

>Does packing or reindexing reassign the RECNO(). I know buffered data has temp recno().
>
>Much Thanks
>Miles
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform