SQLExecDirect - cBaseSQLExecutor

Executes a SQL Query

Type: Procedure

Parameters: String sSQLQuery

ParameterDescription
sSQLQuerySQL Query


Syntax 
Procedure SQLExecDirect String sSQLQuery

Call: Send SQLExecDirect sSQLQuery


Description

Executes a SQL Query.

Sample

Example of SQLExecute without a result set.

Integer iAffectedRows

Send SQLExecDirect of ghoSQLExecutor @SQL"UPDATE Customer
    SET NAME = 'Thomas Hardy', City = 'London'  
    WHERE Customer_Number = 1"

// Test for errors
If (not(Err)) Begin
    Get piSQLAffectedRows of ghoSQLExecutor to iAffectedRows
End