DB Access Class Library for COBOL V1.0 API Reference - Microsoft(R) Windows(R) - - Microsoft(R) Windows NT(R) - - Microsoft(R) Windows(R) 2000 -

Contents Index

Chapter 11 Notes on Using the DB Access Class Library

11.1 Notes on Updating Rows in a Recordset

When the user reference data in a recordset, the DB access class library does not lock the data. If an update to the same resource in the record set occurs while the set is being used, the data in the local cache may not correctly reflect the corresponding data in the database. Notes on updating rows in a recordset are given below.

• When the user uses the EDIT-RECORD method and the UPDATE-RECORD method in the FJDB-RECORDSET class to update data, the local cache and the database are compared with regard to the row of data being updated. This comparison, however, does not cover data of the binary type. If the local cache and the database do not match, the database is not updated to ensure its integrity, with the result that an error is generated.
• While a given resource in a record set is referenced, the EXECUTE-SQL method and the EXECUTE-COMMAND method must not be issued to gain access to the same resource.

Contents Index