once the root folder is set via the ODBC DSN you can use relative
pathing like so.
SQLEXEC("select * from data1customer", "customer")
SQLEXEC("select * from data2supplier","supplier")
but if your using VFP you can just open the table natively right ?
aj wrote:
> I'm trying to make a connection to a bunch of old fox tables using odbc ex(create connection).
> I have access to the folder that I specify as the connection point but I need to drill down into the directory structure. This would allow me to see all the tables in the old database. Anyone been down this road before?
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
©2003 Gene Vital |
