SQLExecute - cBaseSQLExecutor

Executes a prepared SQL query without returning a result set

Type: Procedure

Parameters: None

Syntax
Procedure SQLExecute 

Call: Send SQLExecute


Description

Call SQLExecute to execute a prepared SQL query.

Call the Function with the same name: SQLExecute, to use it with a result set.

Example of SQLExecute Without Result Set

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

// Test for errors
If (not(Err)) Begin
    // Execute the query
    Send SQLExecute of ghoSQLExecutor
End