Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database maintenance options
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00259275
Message ID:
00259412
Vues:
16
>>>I am making a database and table maintenance class that has buttons for PACK, RECALL ALL, and REINDEX, and whatever else I might need. I thought I would add a button that does "Clean Up Database" and VALIDATE DATABASE. As I recall, the "Clean Up Database" pad from the Database menu does the same as:
>>>
>>>USE mydatabase.dbc EXCLUSIVE
>>>SELECT mydatabase
>>>PACK
>>>
>>>Is that the right code?
>>>
>>>So what else do I need to put in this thing?
>>
>>Be aware that VALIDATE DATABASE is not available outside the VFP environment...
>
>...and the RECOVER option is not available in code, only from the Command Window.
The vfp6 help confirms what you say about the RECOVER clause. It doesn't confirm what Eric said about the command itself, but I can believe that he's right.

I don't know if VALIDATE DATABASE would even be a good command to make available to users, if Eric were wrong. I'm open to suggestions about what are good maintenance options to provide users in a very light-duty environment.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform