Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack a table and retain order of records
Message
From
15/12/2004 15:34:54
 
 
To
15/12/2004 15:18:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969565
Message ID:
00969568
Views:
17
John,

>I hate to pack tables because after doing so the data is not in the order it was created. All my tables use a guid for the PK so I believe after they are packed they are in order by the guid.

Not unless you set the order to the primary key.

HTH,

>
>I know I could always set order to transactiondatetime (example) but when I just USE the table and then BROWSE it, I'd just like it to be in the same order it was in before the PACK.
>
>Is there a way?
>
>Thanks,
>John
Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform