Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Records
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00082230
Message ID:
00082407
Views:
34
>Jim,
>
> Thanks for that. Where is the best place to PACK? I don't want any records marked for deletion left in any tables upon exit, if I can see them or not doesn't matter. The size of the tables does matter.
>
>Eric K.

Eric, to PACK you will have to USE the table exclusively. In a multi-user program this could be a problem. Why not re-use any deleted records? I have a small function called "AddDel()" which checks for deleted records. If it finds one it is recalled, the data is blanked, and it is re-used. Otherwise the system issues an Append Blank or Insert depending on the situation (OK, folks, let's NOT start the Append/Insert controversy again :-) ).

If you have an index on Deleted() for each table this works very quickly.

HTH
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform