This one has me stumped. I am using Visual Studio 6.0 and I am trying to pass a SQL Select statement thru ADO to the Visual Foxpro Driver. The statement is a simple
"select * from MyTable into table NewTable"
If I paste the SQL into the Foxpro Command window, it creates the NewTable.dbf, with all the rows in it.
If I send the exact same SQL through an ADO Connection, it does NOT create the table and actually returns the recordset.
Does anyone know how I can get a Select ... Insert statement to work going from VB 6.0 thru ADO 2.7 into VFP 6.0?
"select * from MyTable into table NewTable"
If I paste the SQL into the Foxpro Command window, it creates the NewTable.dbf, with all the rows in it.
If I send the exact same SQL through an ADO Connection, it does NOT create the table and actually returns the recordset.
Does anyone know how I can get a Select ... Insert statement to work going from VB 6.0 thru ADO 2.7 into VFP 6.0?