Share via

IRowsetResynch: Notes

  • Article

Limitations

The OLE DB specification for IRowsetResynch states that providers cannot support this interface (when DBPROP_OTHERUPDATEDELETE is VARIANT_FALSE) if the rowset does not have a different method for retrieving data from the data store. However, the ODBC Provider uses SQLSetPos or SQLExtendedFetch to refresh data for dynamic, keyset-driven, or static cursors. It does not employ another mechanism to refresh the rowset data.

Implementation Notes

To enable the ODBC Provider to expose the IRowsetResynch interface, at least one of the following conditions must be met:

  • The IRowsetLocate interface is implemented.

  • The transaction isolation level is set to SQL_TXN_REPEATABLE_READ.

  • The transaction isolation level is set to SQL_TXN_SERIALIZABLE.

  • The transaction isolation level is set to SQL_TXN_VERSIONING.

DBPROP_CANHOLDROWS is set to VARIANT_FALSE, SQLExtendedFetch and SQLSetPos with REFRESH are available from the underlying ODBC driver, and the cursor is not a forward-only cursor.

This topic is a part of: