UpdateTextWithFile
Structure
UpdateTextWithFile(sTable, sField, sWhere, sFile : String)
Type
Procedure
Description
This function will take a File and update the Database based on the appropriate Table, File, and Where clause. This function works with large text fields.
Parameters
| Parameter | Type | Description |
|---|---|---|
sTable | String | Specifies the name of the table that should be updated |
sField | String | The field name that should be updated |
sWhere | String | The Where clause for the SQL. Example: WHERE GRID_SETTING_NAME = 'TEST' AND IS_DEFAULT = '1' |
sFile | String | sFiles is the location of the file that should be imported and pushed to the database |
Example
UpdateTextWithFile('GAGES', 'GAGE_NOTES', 'WHERE COMPANY = 'ABC COMPANY' AND GAGE_SN = 'ABC-123'', 'C:\MyTextFile.TXT')