FoxPro Help and Support - get a list of tables and fields from a remote connection

Author

get a list of tables and fields from a remote connection

ghj

2005-06-07, 9:24 am

Is there a way to get a list of remote tables (and fields with data types)
from a vfp remote connection database. I am trying to create a routine that
compares table structures of a SQL database with a local VFP database.

(Like in the remote view designer, you can see a list of available remote
tables and fields and datatypes)

Thanks

Stefan Wuebbe

2005-06-07, 9:24 am

"ghj" <ghj@ghj.com> schrieb im Newsbeitrag news:c%gpe.4531$zT2.3935@trndny04...
> Is there a way to get a list of remote tables (and fields with data types)
> from a vfp remote connection database. I am trying to create a routine that
> compares table structures of a SQL database with a local VFP database.
>
> (Like in the remote view designer, you can see a list of available remote
> tables and fields and datatypes)

SQLTables() and SQLColumns() can do so.

hth
-Stefan

--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Sponsored Links