Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database fields and tables
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01057607
Message ID:
01057612
Vues:
19
>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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform