Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way to remove records from a table?
Message
From
10/12/1998 15:49:37
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00166081
Message ID:
00166302
Views:
12
>Hate this "marked for deletion" crap. I come from an SQL environment that when you deleted a record, it was gone. If you wanted to mark records for deleteion, you added a delete flag column to your table. We never allow our clients to see deleted records, and they never have the opportunity to undelete. Yet they have to run a pack and reindex periodically.
>
>Is there a way to truly (madly, deeply) delete records from a table?
>
>Brenda

Yes. If you truly (madly, deeply) want them gone (vamoosed, disappeared, dead, deleted, find a time when you can have exclusive use of the file and issue a PACK command.

I generally have this as part of the reindex utility of any given system with the user option of "Purge Deleted Records"
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Reply
Map
View

Click here to load this message in the networking platform