SQLUtilExecuteQuery - cDbUpdateFunctionLibrary

Executes a SQL string as an embedded SQL statement

Type: Procedure

Parameters: String sStmt String sDriverID


Parameter

Description

sStmt

The embedded SQL statement to execute.

sDriverID

One of MSSQLDRV_ID, DB2_DRV_ID, ODBC_DRV_ID, ORAFLEX, SQLFLEX, MDSPgSQL or MDSMySQL

bShowProgress

Optional. If the backup progress should be shown or not. If the ghoStatusPanel is active - the info will be shown there. Else Showln is used to display the progress percentage.



Syntax


Procedure SQLUtilExecuteQuery String sStmt String sDriverID Boolean bShowProgress

Call:

Send SQLUtilExecuteQuery sStmt MSSQLDRV_ID



Description

Executes the passed string as an Embedded SQL statement.

ESQL (embedded SQL) statements should have "SET NOCOUNT ON" or you might experience strange results. It is the programmers responsibility to check that the format of the sStmt string is correct.


See Also

Adding SQL Keywords