>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