cch_sel_blb

Writes a binary file in the passed BLOB field in the selected record of the active widget and directly into the database.


Parameters:

BLOB FIELD [binary file [location]]

BLOB Field
Name of the BLOB field.

binary file
Name of the binary file. If no binary file is passed, a file selection widget will open.

If, alternatively, <CLEAR> is passed, the function deletes the content of the BLOB field in the database. The third parameter Location must be empty in this case, e.g. cch_sel_blb "T_TABLE1.BLOB1 <CLEAR>".

location
Specifies whether the binary file is fetched from the server or the client (S = server, C or empty = client).


Usage as:

On_Select userexit in Select-Menus/Button-Areas or On_Event userexit in Element-Selection state.


Explanation:

With this userexit it is possible to store binary files directly in the database. It is a prerequisite that a table field of the B type (binary, BLOB = Binary Large Object) exists and that this field is displayed in the mask.

If the BLOB field is displayed in forms and it contains a binary file of the types .BMP or .GIF, the graphics will be directly displayed in the field. The field should correspond to the size of the graphics, but must at least have a size where the column width multiplied with the row length is larger than . In lists the BLOB field is always displayed without its content.