Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid Records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00082230
Message ID:
00082407
Vues:
35
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform