Changing data, also known as updating data, consists of updating and deleting existing rows of data and inserting new rows of data. Consumers can change data either through commands, such as the UPDATE, DELETE, and INSERT commands in SQL, or through rowsets. This chapter discusses how consumers change data through rowsets by calling certain methods in IRowsetChange that alter row data. Two update modes are presented: immediate and delayed. The type of mode affects the state of the row. The visibility of changes is discussed, both as it relates to the state of the row and other changes affecting the row. Inserting rows in the desired position, resynchronizing rows, and refreshing row values are also discussed.
| For more information on | Go to |
| Consumers | Consumers and Providers in Chapter 1, Overview of OLE DB |
| Commands | Chapter 3, Commands |
| Rowsets | Chapter 4, Rowsets |
| Changing data by calling SetData, DeleteRows, and InsertRow in IRowsetChange | Changing Data in this chapter |
| Immediate vs. delayed update mode | Immediate vs. Delayed Update Mode in this chapter |
| The state of the row | Row States in this chapter |
| Visibility of changes | Visibility of Changes in this chapter |
| Other changes affecting the row | Visibility of Other Changes in this chapter |
| Inserting rows in the desired position | Position of Inserted Rows in this chapter |
| Resynchronizing rows | Resynchronizing Rows in this chapter |
| Refreshing row values | "Refreshing Row Values in this chapter |