Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Obtain table names in VFP database
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Obtain table names in VFP database
Versions des environnements
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01172879
Message ID:
01172879
Vues:
68
I have a oledb connection to vfp database from net project. I need tables name list of vfp database and fields of any selected table of this database. How can I obtain this information by oledb connection.

I use this command if I connect to sqlserver.
"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES Where OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable')=1"


thanks in advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform