<< 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 := NIL REF USUAL,  lOptions := -1 AS LONG )   AS AdoRecordSet 

METHOD Execute ( cCommandText AS STRING, lRecordsAffected OUT LONG,  lOptions := -1 AS LONG )   AS AdoRecordSet 

 

Argument(s)

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

lRecordsAffected        (Optional OUT). 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