>>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.