Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to free a table?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00184152
Message ID:
00184208
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform