Below are details of the properties and methods of the ADO Connection object
Property Name | Description |
ActiveConnection
|
The associated Connection Object |
CommandText
|
The query String |
ComandTimeout
|
The amout of time before the execution is aborted. Default is 30 seconds |
CommandType
|
A hint at the type of query string adCmdText 1 adCmdTable 2 adCmdStoredProc 4 adCmdUnknown 8 |
Prepared
|
Indicate whether the command should be precompiled |
Method | Parameters |
CreateParameter(n,t,d,s,v)
|
n = Name of the parameter
s= The Maximum size of the parameter |
Execute(count, parameters, options)
|
A parameter object also has a AppendChunk
method, and a GetChunk
method. These add/retrieve data from the parameter.
Comments