|
|
|
|
|
|
|
PROPERTY: |
|
|
|
|
commandType |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
Indicates the type of command. |
||
|
|
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
|
||
|
|
|
||
|
|
VALUE: |
DESCRIPTION: |
|
|
|
0 |
Unspecified (Default) |
|
|
|
1 |
Text |
|
|
|
2 |
Table |
|
|
|
3 |
Table Direct |
|
|
|
4 |
Stream File |
|
|
|
5 |
Stored Procedure |
|
|
|
|
||
|
|
DESCRIPTION: |
|
|
|
|
If the commandType property value equals 0 (Unspecified), you may experience diminished performance because ADO must make calls to the provider to determine |
||
|
|
if this property is an SQL statement, a stored procedure, or a table name. |
||
|
|
If you know what type of command you're using, setting the commandType property instructs ADO to go directly to the relevant code. |
||
|
|
|
||
|
|
If the commandType property does not match the type of command in the commandText property, an error occurs when you call the Execute method. |
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|