[AccessD] ADO OpenRecordest with Update

Charlotte Foust cfoust at infostatsystems.com
Wed Oct 15 11:34:49 CDT 2003


Action queries like update or append do not return recordsets.  You can
execute them using ADO, but you can't make them return rows.

Charlotte Foust

-----Original Message-----
From: Drawbridge.Jack at ic.gc.ca [mailto:Drawbridge.Jack at ic.gc.ca] 
Sent: Wednesday, October 15, 2003 6:46 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] ADO OpenRecordest with Update



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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list