Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Knowing tables names in remote server ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00759359
Message ID:
00759370
Vues:
13
Thankx much!!

>>Hello everybody,
>> I need to retrieve data from a mainframe via OBDC using VFP7,
>>I can get a connection, but I need to know the name of the tables that
>>are available to me, like the way Excel does it when you select
>>"New Database Query" from the option menu "Get External Data" it shows you a list with the name of the tables, or like in SQL, something like
>>lnRtn = SQLEXEC(lnHandle,"EXEC sp_tables"), is there a generic command for ODBC that lets you accomplish the same?, How does Excel do it?
>>
>>=THIS.Thanks("In advance")
>
>SQLTABLES()
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform