ADO Command Object
- Last Updated: May 12, 2026
- 3 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The Command object can be used to specify a database query in the language native to the database server. For a relational data provider, this is usually a SQL statement.
The Execute method for the ADO Command object maps to the OLE DB method, ICommand::Execute.
The following table lists the dynamic properties that are supported by the ADO Client for the Command object.
Dynamic Properties Used for the ADO Command Object
| ADO Property | Default Value and Description |
| Access Order | VALUE=2. Columns can be accessed in any order. |
| Blocking Storage Objects | VALUE=False. Instantiated storage objects do not prevent the use of other methods. |
| Change Inserted Rows | VALUE=False. The value can only be set to True if the rowset is using a keyset-driven cursor. |
| Column Privileges | Specifies whether access rights are restricted on a column-by-column basis.VALUE=True. Access rights are restricted on a column-by-column basis. VALUE=False. Access rights are not restricted on a column-by-column basis. If the rowset exposes IRowsetChange, SetData can be called for any column in the rowset. |
| Fetch Backwards | VALUE=False. cRows must be non-negative. |
| Hold Rows | VALUE=True. Access rights are restricted on a column-by-column basis. |
| IAccessor | VALUE=True |
| IColumnsInfo | VALUE=True |
| IColumnsRowset | VALUE=True |
| IConvertType | VALUE=True |
| IRowset | VALUE=True |
| IRowsetChange | VALUE=False |
| IRowsetInfo | VALUE=True |
| Literal Row Identity | VALUE=False. The consumer must call IRowsetIdentity::IsSameRow to determine whether two row handles point to the same row. |
| Lock Mode | VALUE=1. The ADO Client is not required to lock rows at any time to ensure successful updates. |
| Maximum Open Rows | Specifies the maximum number of rows that can be active at the same time. VALUE=4096 |
| Maximum Pending Rows | VALUE=0. There is no limit on the number of rows that can have pending changes at the same time. |
| Maximum Rows | VALUE=0. There is no limit on the number of rows that can be returned in a rowset. |
| Memory Usage | VALUE=0. There is no limit on the amount of memory that can be used by the rowset. |
| Objects Transacted | VALUE=True. Any object created on the specified column is transacted. |
| Others' Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by others. |
| Others' Inserts Visible | VALUE=False. The rowset cannot see inserts made by others. |
| Own Changes Visible | VALUE=False. The rowset cannot see updates and deletes made by consumers of the rowset unless the command is executed again. |
| Own Inserts Visible | VALUE=False. The rowset can see the rows inserted by consumers only after the command is run again. |
| Preserve on Abort | The value depends on the OpenAccess SDK service that you are using. |
| Preserve on Commit | The value depends on the OpenAccess SDK service that you are using. |
| Quick Restart | VALUE=True. IRowset::RestartPosition is relatively quick to execute. It does not again execute the command that created the rowset. |
| Remove Deleted Rows | VALUE=False. Static cursors do not remove deleted rows. |
| Report Multiple Changes | VALUE=False. An update or delete always affects a single row or the ADO Client cannot detect whether it affects multiple rows. |
| Return Pending Inserts | VALUE=False. The methods that fetch rows cannot return pending insert rows. |
| Row Privileges | VALUE=False. The ADO Client does not set access restrictions for rows. |
| Row Threading Model | VALUE=1. The ADO Client uses the free-threaded model. |
| Scroll Backward | VALUE=False. IRowsOffset must be non-negative. |
| Server Cursor | VALUE=False. The ADO Client determines where to locate the cursor. |
| Strong Row Identity | VALUE=False. There is no guarantee that the handles of newly inserted rows can be compared successfully. |
| Unique Rows | VALUE=False. Rows in the rowset may or may not be uniquely identified by their column values. |
| Updatability | Specifies the supported methods on IRowsetChange. VALUE=0 |
| Use Bookmarks | VALUE=False. The rowset does not support bookmarks. |