Effect of Changes on the Next Fetch Position

OLE DB Programmer's Reference

The next fetch position is unaffected by updates, deletes, and inserts. However, the definition of unaffected is provider specific due to the complexity of implementation strategies.

For example, suppose the current index applies to column 1, which has values in succeeding rows of "A", "B", "C", "D", "E", and "F". If the last row fetched contains the value "C" and the consumer changes this value to "EE", in most cases the next row fetched will contain the value "D", not "F". Assuming changes are visible, they will be fetched in the expected order. For example, if the last row fetched contains the value "C" and the consumer changes this value to "CC", the next row fetched might contain the value "CC" or "D".

1998-2001 Microsoft Corporation. All rights reserved.