Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic paths in Database
Message
From
27/01/1999 13:38:06
 
 
To
27/01/1999 13:17:22
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00180908
Message ID:
00180922
Views:
15
>Is there any way to change the paths of the tables in a database at runtime? Then the user can select where to have each table of the database and even change these paths dynamically.
>
>I have seen the 'path' property in DBGETPROP() and DBSETPROP() but it says that the property is Read-Only.
>
>Thanks

I don't know about each table being in a different place, but I have multiple copies of the same database (with different data) in different directories. I do in the before open tables of the data environment:

Thisform.SetAll("Database",pcDBCpath,"Cursor")

Where pcDBCpath is the path to the appropriate database direcory. You could probably set each table's path seperately if they're free tables. I don't know how you'd do it in a database. But if you set your path to all the directories that have the tables, VFP will find the table. Just make sure you don't have a different table at the path that is hardcoded.

-Michelle
Previous
Reply
Map
View

Click here to load this message in the networking platform