I could open the table natively but im trying to demonstrate something to my
boss :)
I have no other sample database to work off of so im using an old fox table
to demonstrate
Trying to show them that any db will work.
Thanks
A.J.
----- Original Message -----
From: "Gene Vital" <genevital (AT) karibe .D.OT com>
To: "ProFox Email List" <profox@leafe.com>
Sent: Tuesday, September 30, 2003 3:56 PM
Subject: Re: ODBC problem
> 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 aj |
