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 & ''')
See also
ReturnFromSQL