RunSQLComplex

Structure

RunSQLComplex(sSQL, sAction)

Parameters

| Parameter | Type | Description
| sSQL | String | the sql to be run against the IndySoft database. The sql should NOT end with a semicolon.sAction | String | Must be either 'OPEN' or 'EXEC'. This determines whether an Open action is called or an ExecSQL. If using ReturnFromSQL or RunSQL IndySoft auto-determines this from the presence of SELECT keyword at start - but in complex scenarios this is not always the case (DECLARE section, calling a stored procedure, etc.) |

Description

This function is used to execute sql against the IndySoft database. Note: this function works much like RunSQL, but does NOT do any automatic addition of NOLOCK syntax for SQL Server, and does NOT auto-insert owner from connection settings - this must all be done in sql text.

Example

RunSQLComplex("UPDATE GAGES SET GAGE_OWNER = 'TEST' WHERE COMPANY = '" &

LookupEquipmentCompany & "' AND GAGE_SN = '" & LookupEquipmentID & "'", "EXEC")

Application Compatibility

IndySoft Calibration Management, IndySoft Commercial Lab Management, IndySoft Tool Management

Also See

ReturnFromSQLComplex |