Element "UpdateBLOBFieldProcess"

UpdateBLOBFieldProcess should be used inside a process form. It is used to load files into the BLOB type fields of the tables. The capacity of the file BLOB fields may differ from one Database to another.

Parameters

Connection Name (Accept MScript)

The name of the JDBC connection defined with RelDBConnection element in the Global Definitions page.

Query (SQL) (Accept MScript)

This property should include a query to select the  records whose BLOB type fields to be updated. All the primary key fields and the BLOB fields to be updated need to be selected to include them in the result set.

Example:

SELECT ID, SMALL_PICTURE, BIG_PICTURE WHERE ID = @vof(ID)

 
In this example ID field is chosen since in is the primary key and SMALL_PICTURE and BIG_PICTURE fields are chosen since they will be updated.

BLOB Assignments (Accept MScript)

This property can be given one or more BLOB field assignments by defining each one on a separate line.

The syntax for each line:

BLOB_FIELD_NAME = FILE_NAME

BLOB_FIELD_NAME 

The name of a BLOB field that exists in the result set.

FILE_NAME 

An MScript expression that resolves to a file name. The content of the file will be transferred to the given BLOB field. The file name can be absolute or relative to the root directory of the web application.

 
Examples:

SMALL_PICTURE = 'WEB-INF/MM-INF/~tempfile/200602061530.gif'

BIG_PICTURE = FOLDER_NAME + '/' + FILE_NAME