ActiveX Data Objects: Difference between revisions

Revision as of 05:50, 16 March 2017

Revision as of 14:57, 25 July 2017

Line 34:

: A recordset is a group of records, and can either come from a base table or as the result of a query to the table. The RecordSet object contains a Fields collection and a Properties collection. The Fields collection is a set of Field objects, which are the corresponding columns in the table. The Properties collection is a set of Property objects, which defines a particular functionality of an OLE DB provider. The RecordSet has numerous methods and properties for examining the data that exists within it. Records can be updated in the recordset by changing the values in the record and then calling on the Update or UpdateBatch method.

; Immediate

: The recordset is locked using the adLockOptimistic or adLockPessimisticadLockPessimistic5 lock. The data are updated at the data source after the record is changed and the Update method is called.

; Batch

: The recordset is locked using adLockBatchOptimistic and each time Update is called the data are updated in a temporary buffer. Finally, when UpdateBatch is called the data are completely updated back at the data source. This has the advantage of it all being done in memory, and if a problem occurs then UpdateCancel is called and the updates are not sent to the data source.