MDAC 2.5 SDK - ODBC Programmer's Reference
Chapter 12: Updating Data
Deleting Rows by Bookmark with SQLBulkOperations
When deleting a row by bookmark, SQLBulkOperations makes the data source delete one or more selected rows of the table. The rows are identified by the bookmark in a bound bookmark column.
To delete rows by bookmark with SQLBulkOperations, the application does the following:
- Retrieves and caches the bookmarks of all rows to be deleted. If there is more than one bookmark and column-wise binding is used, the bookmarks are stored in an array; if there is more than one bookmark and row-wise binding is used, the bookmarks are stored in an array of row structures.
- Sets the SQL_ATTR_ROW_ARRAY_SIZE statement attribute to the number of bookmarks and binds the buffer containing the bookmark value, or the array of bookmarks, to column 0.
- Calls SQLBulkOperations with Operation set to SQL_DELETE_BY_BOOKMARK.