Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to make a copy of a DBC during runtime
Message
De
23/05/2008 20:58:35
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to make a copy of a DBC during runtime
Divers
Thread ID:
01319312
Message ID:
01319312
Vues:
72
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform