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:
00184325
Views:
16
On top of suggestions Arne and Josh gave you, remember that a free table doesn't support long field names so if some fields names get truncated you will have to change the reference to them in your app.


>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
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform