Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADODB and VFP tables
Hi All,
I'm not sure that this is the appropriate category to post this, but, here goes.
I've managed to create an ADODB recordset from a single VFP7 table that currently sits in a particular folder. I'm using a connection string with Provider set to VFPOLEDB and the Data Source points to the folder where the table exists.
I now want to create a different recordset using Open(SQL select...) where the SQL select takes data from two VFP tables. My problem is that the tables are located in separate folders and I don't know how or if its even possible to make this work. As far as I can see, the Data Source only points to one folder. How do I get it to look into another folder where the second VFP table is located?
Anyone know if this can be done?
TIA
Regards,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only