The Command object is not typically needed because stored procedures and queries are not available in D3 and the Connection object allows execution of commands. Nonetheless, it can be used to execute SQL statements in the same way as the Execute method of the Connection object.
The Command object has the three methods shown in the following table. One of these methods is available to developers using the OLE DB Provider for ODBC with D3 ODBC.
| Command Methods | Available |
|---|---|
| Cancel | No |
| CreateParameter | No |
| Execute | Yes* |
*Available options – adCmdText, adCmdTable
The Command object has the seven properties shown in the following table. Three of these properties are available to developers using the OLE DB Provider for ODBC with D3 ODBC.
| Command Properties | Available |
|---|---|
| ActiveConnection | Yes |
| CommandText | Yes |
| CommandTimeout | No |
| CommandType | Yes* |
| Name | No |
| Prepared | No |
| State | No |
*Available options – adCmdText, adCmdTable, adExecuteNoRecords Error object