Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving DataBase to another Directory
Message
From
10/07/2002 17:19:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Moving DataBase to another Directory
Miscellaneous
Thread ID:
00677263
Message ID:
00677263
Views:
58
Hi again...
When you design and create your VFP program, you set up diferent directories for all the parts of the proyect, that is for example: c:\SINFO for the main prgs, c:\SINFO\FORMS for all the forms, c:\SINFO\CLASSES for classes, and c:\SINFO\DATA for the database. When in the dessign proccess you create your forms and set its data enviroment to certain tables of the c:\SINFO\DATA\SINFO.dbc. In the main prg you open the c:\SINFO\DATA\SINFO.dbc, no problem at this time. But if for any reasson you decide to change the name of your data directory to c:\SINFO\DATADBC\SINFO.dbc so you change the Open dbc command of the main prg and it opens the right database but all the forms still trying to open its tables in the original directory. I looked at the properties window of the form´s cursors and it shows in the DataBase property the original directory and it seems to be read only. So in the future when you distribute the application it will be in all the clients desktops but the database will be in another computer (server) so the directory will be something like \\juanpc\c\SINFO\DATA\SINFO.dbc insted of C:\SINFO\DATA\SINFO.dbc
How to fix this?

Thanks Juan Uribe
Next
Reply
Map
View

Click here to load this message in the networking platform