[AccessD] ADO OpenRecordest with Update

Drawbridge.Jack at ic.gc.ca Drawbridge.Jack at ic.gc.ca
Wed Oct 15 09:45:53 CDT 2003


Is it possible to have an ADO openrecordset ("sql_string") where the
sql_string is an UPDATE statement? I see examples with SELECTs but no
Update.

We are getting error 3219 Invalid Operation
  
 mySql = "UPDATE MyTable SET item_ref_date = Now()
  WHERE item_id = 16;"

Thanks

jack


More information about the AccessD mailing list