Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Command > ADODB_Command Methods >

<ADODB_Command>.Execute

Previous pageReturn to chapter overviewNext page

 

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