Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'USE EXCLUSIVE' in a 24 / 7 Environment
Message
De
22/05/1998 16:21:06
 
 
À
22/05/1998 16:14:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00101295
Message ID:
00101297
Vues:
19
Sorry, but there are no way to pack a table without opening it exclusively.

2 suggestions:
1) Reserve 1 hour (more or less) per week (or by month) for maintenance

2) Reuse deleted record when adding new one

>I have been asked to write an utility in VFP 5.0 to perform data maintenance on tables being acccessed by a FPW 2.6 application. This is a multi-user program being used twenty four hours a day, seven days a week.
>
>This may seem like a stupid question, but can anyone think of a way to PACK tables, PACK MEMOs and re-create index tags without getting EXCLUSIVE use of the tables?
>
>I am aware of a way to build an application where forms are going against offline views using the new CREATEOFFLINE() function. In such a scenario, data maintenance can be performed while users are working off-line. I am also aware that offline views can be based on FPW 2.6 tables without modifying the table headers. Unfortunately, my client is not prepared to re-write this gargantuan legacy application at the present time.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform