Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I have a database and want to change to path of my table
Message
 
 
To
11/10/2000 09:12:22
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00427505
Message ID:
00427793
Views:
13
>>>>>In vfp60, I have a database and want to change to path of my tables. This path is where the database looks for it's member tables.
>>>>>I want to change the path of those tables. any ideas?
>>>>
>>>>What path do you want to change? SET PATH TO ...? The path in the DE of your forms?
>>>Hi Mark... When I OPEN DATA mydatabase and LIST TABLES..I get a list of
>>>the database's tables with the tables paths...SET PATH TO... in this case, does not do anything...:)
>>
>>LIST TABLES just lists all the tables in the current DBC. The additional path information provided is irrelevent. If you moved the entire folder containing the DBC, DCX, DCT, DBF, CDX files to another folder, the path displayed would change relative to where you moved the folder.
>---
>Good Morning Mark:
>I copied a DATABASE with some of it's tables into a directory. I can OPEN
>DATA mydatabase without any problems. When I type in USE mytable, I get a message saying... FILE another_path\mytable DOES NOT EXIST.... It looks like the DATABASE is looking for the table in a predifined path even if the table
>is in the same directory as the DATABASE....I do not know whats up...:)

In your original folder, I would:

CLOSE ALL
OPEN MYDBC EXCL
VALIDATE DATABASE RECOVER

Correct any errors. Then COPY all the files in that folder to another folder and retry your test.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform