Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup from within an App
Message
De
31/01/2011 18:40:09
 
 
À
31/01/2011 16:03:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01498044
Message ID:
01498068
Vues:
53
>I'd like to incorporate backup capability from within an app.
>
>Any source code lying around that could help me with that?

Since DBFs DBCs cannot be backed up while open, a multiuser VFP app generally needs to use sql select statements to copy data to structurally identical tables in a a backup dbc ( which, of course, can be created with a single gendbc statement so it is empty and waiting for the data. ) That's the only way I know of to do it without kicking everyone out of the app and closing all the data (which also means designing so any config tables that would be used as part of the backup be freetables that can remain open after the dbcs are closed ) But kicking everyone out on the network is generally considered very user unfriendly so I'd go with either SQL Selects or append from ( which is trickier as you will have DBCs and tables with the same names )


Or, you could do it the right way and use SQL Server ( g, d & r )


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform