With respect to ADO can somebody tell me the differance between Update and UpdateBatch
Printable View
With respect to ADO can somebody tell me the differance between Update and UpdateBatch
Easy... Update is used with connected recordsets (that still have an open & valid connection to the data source) to send the changes to the current record back to the database.
UpdateBatch is primarily used with disconnected recordset to send a batch of updated back to the database (after it's been re-connected). I've done this a lot, get RS, diconnect it, perform data changes, reconnect and update batch. THe key to this one is when getting the recordset, amking sure it's opened with the batch operation setting on.
Tg
Cheers techgnome