Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to free a table?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00184152
Message ID:
00184208
Vues:
24
>I need to localize one of my existing tables to each local machine. To do this, I thought I can just use a copy of the table with the .exe on each local machine and delete the copy that exists on the server with the other tables. I moved the table files (dbf, cdx, fpt, tbk) using the Windows Explorer. However, when I tried to run the app I got this error: "the table file has moved, please validate database".
>
>I tried another approach by removing the table from the project manager then moving the files. This time, when I tried to start the program, I got this error "Error instantiating cursor object. Cannot find table file in .dbc file". If I click on "Locate" and select the file, it will work, but if another form tries to access the table, then the same error occurs again.
>
>How can I fix this?
>
>Mon

FREE TABLE, like Josh said, is the command to free the talbe from the database, but you have another problem on your hands: all of your forms think that the table in their DE belongs to a database. This information is hardcoded into the Form.DataEnvironment.Cursor.Database property. Quickest (maybe the only) fix for this is to go into each form, remove the table from the DE, and add it back in as a free table.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform