Visibility of Changes in the Index

OLE DB Programmer's Reference

The visibility of pending changes in the index is governed by the same mechanisms that govern the visibility of pending changes in the base table, with one important difference: If an index column in a row is updated, this is considered to be the same as deleting that row from the index and inserting a new row with the new value. Therefore, the visibility of pending deletes for completely released and refetched rows depends on whether the rowset exposes IRowsetIdentity. The visibility in the index of pending inserts depends on DBPROP_RETURNPENDINGINSERTS. Pending updates to key columns might not appear in the correct position in the index until the update is transmitted to the data store.

The visibility in the index of transmitted changes is governed by the same mechanisms that govern the visibility of transmitted changes in the base table. In other words, it depends on the DBPROP_OWNUPDATEDELETE, DBPROP_OWNINSERT, and DBPROP_REMOVEDELETED properties.

1998-2001 Microsoft Corporation. All rights reserved.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net