Updating Data in Rowsets (OLE DB)

Consumers can change row data either through commands, such as the UPDATE, DELETE, and INSERT commands in SQL, or through rowsets. This section discusses how consumers, by calling methods in IRowsetChange, change row data through rowsets. Two update modes are presented: immediate and deferred. The visibility of changes is discussed, both as it relates to the state of the row and as it relates to other changes affecting the row. Inserting rows in the desired position, resynchronizing rows, and refreshing row values are also discussed.

This section contains the following topics:

• Changing Data

• Immediate vs. Deferred Update Mode

• Row States in Deferred Update Mode

• Visibility of Changes