Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detecting the directory of a table
Message
From
17/02/2003 20:20:38
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00754146
Message ID:
00754306
Views:
20
Hi Michael,

Try ;
?DBF("myalias")

It returns the path and file name for an alias. I use it frequently for creating a read/write cursor in VFP 6.

e.g.
SELECT * FROM STAFF INTO CURSOR CURTEMP WHERE GENDER = "MALE"
USE DBF("CURTEMP") AGAIN IN 0 ALIAS MALESTAFF
USE IN CURTEMP

You will find MALESTAFF is read/write. Hope that this helps.
Previous
Reply
Map
View

Click here to load this message in the networking platform