SQLExecute - cBaseSQLExecutor

Executes a prepared SQL query and returns a result set

Type: Function

Return Data Type: Variant

Parameters: None

Return Value


Syntax
Function SQLExecute Returns Variant

Call: Get SQLExecute to VariantVariable


Description

Call SQLExecute to execute a prepared SQL query.

Call the Procedure with the same name, SQLExecute, to use it without a result set.

Example of SQLExecute With Result Set

String[][] aResults

// Prepare the query
Send SQLPrepare of ghoSQLExecutor @SQL"SELECT
    Name,  
    City,
    Zip
    FROM Customer"

// Test for errors
If (not(Err)) Begin
    // Fetch the results into aResults
    Get SQLExecute of ghoSQLExecutor to aResults
End

See Also

SQLPrepare