Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database fields and tables
Message
 
To
10/10/2005 07:18:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01057607
Message ID:
01057612
Views:
17
>Hi
>How can I get a list of my databse tables and fields?
>Thank you

1) Check the DISPLAY DATABASE or DISPLAY TABLES commands
2) the database is in fact a foxpro table as any other, so assuming you have a database named Chaim, you can do stuff like this:
use chaim.dbc
browse
*** if you want to see only tables ****
set filter to allt(upper(objecttype))="TABLE"
browse
** etc...
Check out the objecttype field, and objectid and parentid. With it you can write easily a small program that scans for the tables, gets the id for the specific table, and lookup for all fields with this parentid...

HTH
Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Reply
Map
View

Click here to load this message in the networking platform