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: 4

| Parameter | Type | Description
| sTable | String | Specifies the name of the table that should be updatedsField | String | The field name that should be updatedsWhere | 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') |