[AccessD] ADO OpenRecordest with Update -Thanks

Thanks all for the quick responses.
We could do the execute or or runsql
but didn't understand why we could not do the openrecordset with update.
Makes sense now.

Thanks all.

jack

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Wednesday, October 15, 2003 12:35 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] ADO OpenRecordest with Update


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