>I've got a web application that captures user data and comments, performs some ADO SELECTS to find the user id/status/info, then dumps the data to a VFP table using an ADO connection and INSERT command. I'm getting an ODBC Error:
Hi, Bryan,
I´ve had such a problem in the past, and solved using the recordset to insert the data (instead of the Insert-SQL)... something like this:
oRS.AddNew()
oRS("MyField1") = myValue1
oRS("MyField2") = myValue2
oRS.Update()
Make a try. :)
HTH
Claudio Lassala