<< Click to Display Table of Contents >> Navigation:  Ado Classes > AdoConnection Class > AdoConnection:Execute()

Purpose

Executes the specified query, SQL statement, stored procedure, or provider-specific text.

 

Prototype

METHOD Execute ( cCommandText AS STRING, lRecordsAffected AS USUAL,  lOptions AS USUAL )   AS AdoRecordSet PASCAL CLASS AdoConnection

 

Argument(s)

cCommandText        A String that contains the SQL statement, table name, stored procedure,        a URL, or provider-specific text to execute.

lRecordsAffected        (Optional byRef). A Long variable to which the provider returns the number of records that the operation affected.

lOptions        (Optional)A Long value that indicates how the provider should evaluate the CommandText argument. Can be one or more CommandTypeEnum or ExecuteOptionEnum values.

 

 

Return

OBJECT        AdoRecordSet Object

 

See Also

AdoConnection, AdoRecordSet, AdoCommandTypeEnum, AdoExecuteOptionEnum