UpdateBlobWithFile

Structure

UpdateBlobWithFile(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 binary 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:

UpdateBlobWithFile('PROCS2', 'PROC_FILE', 'WHERE COMPANY = 'ABC COMPANY' AND PROC_NAME = 'MY PROCEDURE'', 'C:\MyFile.PDF') |