<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Command > ADODB_Command Methods > <ADODB_Command>.Execute |
Description
Executes the query, SQL statement or procedure specified in the CommandText property of the Command object.
The results are stored in a new Recordset object if it is a row-returning query.
A closed Recordset object will be returned if it is not a row-returning query.
Syntax
ADODB_RecordSet = <ADODB_Command>.Execute ([lRecordsEffected] )
Returns
An optional RecordSet object
Parameters
Name |
Type |
Optional |
Meaning |
lRecordsEffected |
Variable |
Yes |
Optional. Returns the number of records affected by a query. For a row-returning query, use the RecordCount property of the Recordset object to count of how many records are in the object. |
Remarks
Restrictions
See also
Examples