General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to make a copy of a DBC during runtime
I need to make a copy of a database (DBC/DBT/DCX) to another directory at runtime.
1) The DBC is OPEN, yet I can copy it fine with Windows Explorer and the copy can be OPEN DATABASE.
2) VFP doesn't allow doing a COPY FILE for all three files because the database is OPEN (in use).
3) I tried USEing AGAIN the DBC as a table and then COPY TO, but the copy is not recognized as a database and cannot be opened. All deleted records are gone from DBC copy but all remaining records are identical. hmmm
4) I then USED AGAIn the DBC as a table, SET DELETED OFF, COPYed TO, (which preserved the records, although not deleted) then deleted appropiate records in copy, but copy is still not recognized as a database grrr
5) I even trid doing a SQL SELECT with deleted off and then deleting the appropiate record, but again no.
What is needed may be to make a Windows copy via some shell, but I don't now how to do this.
Any suggestions?
Alex
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only