Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup from within an App
Message
From
31/01/2011 18:40:09
 
 
To
31/01/2011 16:03:32
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01498044
Message ID:
01498068
Views:
52
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform