Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get the DBF name
Message
From
08/05/2001 18:30:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00505043
Message ID:
00505051
Views:
25
>>The closest I can think of is
>>
>>DBGETPROP("TableName", "Table", "Path")
This is the file name and path relative from the DBC.
>
>Son of a gun! That is it. How intuitive! From the VFP Help file under Table properties which I did check first:
>
>Path [C] The path to the table. Read-Only.
>
>In actuality, this returns exactly the DBF file name WITHOUT the path to the file. Go figure. Thanks.

You're welcome.

Actually, just like the Classloc field in a VCX, it's the path relative to the file, which means if the DBC and the DBF are in the same directory - which they probably are in 99.9% of apps that use DBCs - it will return just the file name.
If for some ungodly reason the table is on a different drive than the DBC, then it will return the full path. < shudder >
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform