RunSQL

Structure

RunSQL(sSQL)

Parameters

| Parameter | Type | Description
| sSQL | String | the sql to be run against the IndySoft database. The sql should NOT end with a semicolon. |

Description

This function is used to execute sql against the IndySoft database. Note: this function requires uppercase for SQL keywords such as WHERE, FROM, UPDATE, DELETE, INSERT, etc.

Example

RunSQL('UPDATE GAGES SET GAGE_OWNER = 'TEDT' WHERE COMPANY = '' &

LookupEquipmentCompany & '' AND GAGE_SN = '' & LookupEquipmentID & ''')

Application Compatibility

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

Also See

ReturnFromSQL |