Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-User DBC setup
Message
From
27/11/2006 06:06:07
 
 
To
25/11/2006 21:41:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172353
Message ID:
01172594
Views:
12
>Mike,
>
>From my testing, the DBC stores a relative path to the tables. However, if the folder the DBC is in, is a root folder, it will store a full path to the data, including the drive letter.
>
>I've been trying to find a way around this for awhile, without any solution.


What it is the problem, and why in root ??

If you store DBC and dbfs in the same (sub)folder, there will be NEVER any problem with paths. Relative path twds tables that is stored in dbc in this case is none. You can (re)position your databases&tables as u r pleased
afterwards.

Real complexity with data & paths is to handle that app always use relative path rather then hardcoded absolute path when opening their data.

Once you resolve problem with DE cursors (forms/reports) opening stubornly their hardcoded dbc paths , the rest is easy.
By entrusting some global object or fuctionality, to always supply current path to any database that is used by app, your paths become relative,
and your databases/apps trully movable.
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform