Information générale
Catégorie:
Codage, syntaxe et commandes
>>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement