ADO Command Object
- Last Updated: May 12, 2026
- 3 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
Note: The ADO and ADO.NET clients are currently available only in OpenAccess SDK 8.1. However, they are compatible with the OpenAccess SDK 9.0 server.
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. |