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
| 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
UpdateBlobWithFile('PROCS2', 'PROC_FILE', 'WHERE COMPANY = 'ABC COMPANY' AND PROC_NAME = 'MY PROCEDURE'', 'C:\MyFile.PDF')