Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Knowing tables names in remote server ???
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Knowing tables names in remote server ???
Miscellaneous
Thread ID:
00759359
Message ID:
00759359
Views:
57
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")
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Next
Reply
Map
View

Click here to load this message in the networking platform