Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid database - ouch
Message
 
 
À
14/06/1999 11:49:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00229469
Message ID:
00229481
Vues:
26
>VFP says my database is invalid. I can live with that. But I can't seem to fix it. Here's what happened. I am building an application based on an existing app written in Clipper. I built the database nd the tables in VFP6. I built an exact replica of the tables in Clipper along with an conversion program to drag data out of the old and into the new formats. I used the VFP database & tables for setting up the screens and added some data for testing. When that was complete; I copied a set of the converted tables to the test area and tried to run the VFP program. Stupid move... Now I get a message saying the database is invalide. When I try to validate it, the messages say that 3 of the 5 tables have structures that do not match the database. I have checked and that does not seem to be true but I don't know how to fix it.
>
>Can someone help me heal this hole I've shot in my foot???

In summary:

1. You created a VFP 6 DBC and created new tables as members of the DBC.
2. You created another set of tables with the same structures as the tables in the Clipper app.
3. You developed a conversion program to transfer data from the old to the new formats.
4. You copied the converted tables to the test area for use by the VFP app.

If the above is true, I do not understand step 2 unless you just did not want to do the conversion on the live Clipper tables. I have done a conversion program to convert from a FPD 2.6 app to VFP 6 app. What I did was similar in that I ran a VFP6 app to convert the data which opened the FPD tables and inserted the data one-record-at-a-time [after some massaging] into the VFP tables.

When you did step 4, did you copy all the VFP tables and the DB files [MyDB.DBC, MyDB.DCX and MyDB.DCT] to the test area?
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform