Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleted Record Cleanup
Message
De
23/03/2004 03:57:57
 
 
À
22/03/2004 20:02:34
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00888717
Message ID:
00888764
Vues:
9
Hi Steven,

I suggest that when the pack routine starts, you create a file pack.go, and that you always check for the pack.go file on startup. If the pack.go exists, your users gets a warning and are asked to restart the program in a minute or two. After tha packing, you delete the pack.go file. I have used this procudere for many years.

>I would like some advise on packing my app tables. Currently I have my app set up so that when the first user logs on to the app each day a cleanup procedure runs. Each table I want cleaned is set to exclusive, packed then Use In 0 is performed. One draw back to this is not everyone logs off every evening so there may be several days when the app does not have only one user having use of the tables. The second draw back is every once in a while two users log in at approx the same time. While the one user has the tables pulled up exclusively the other user gets an error that File access is denied. Every thing is okay after the cleanup is process. Any ideas on improving this process would be welcome?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform