SQLExecDirect - cBaseSQLExecutor

Executes a SQL Query and returns a result set

Type: Function

Return Data Type: Variant

Parameters: String sSQLQuery

ParameterDescription
sSQLQuerySQL Query


Return Value

Result set.


Syntax 
Function SQLExecDirect String sSQLQuery Returns Variant

Call: Get SQLExecDirect sSQLQuery to VariantVariable


Description

Executes a SQL Query and returns a result set.

See cSQLExecutor for more information about result sets.

Sample

Example of a query with a result set.

String[][] aResults 

// Fetch results into aResults
Get SQLExecDirect of ghoSQLExecutor @SQL"SELECT
    Name,  
    City,
    Zip
    FROM Customer" to aResults

// Test for errors
If (not(Err)) Begin
    // Process results here..
End