I am trying to write to a table using SQL Passthru from a record object created from the scatter command. I basically scattering to an object modifying the properties and wish to insert the changes back.
I can't build the text because in some cases the values include quotes and such, but even in the most simple cases it is not working.
oRec.Field1 = 'Test1'
oRec.Field2 = 123
if I do:
sqlexec(iCH,'insert into table (field1,field2) values (oRec.Field1,oRec.Field2)
the record is inserted, but the field are blank
if I do:
sqlexec(iCH,insert into table (field1,field2) values (?oRec.field1, oRec.Field2)
I get a returned (-1) where the aerrors method tells me:
Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Data type mismatch.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement