Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a way to remove records from a table?
Message
De
10/12/1998 15:49:37
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00166081
Message ID:
00166302
Vues:
10
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform