skip to main content
Developing ADO Applications : Mapping ADO Methods and Properties : ADO Command Object
 

ADO Command Object

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.
 
Table 17: 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.