In Profound UI version 6 fix pack 3.0 and newer its possible to load the contents of an image directly from a Binary Large Object (BLOB) column in a database table. A BLOB is a feature of the database that can store a large amount of binary (non-text) data, and is commonly used to store pictures. Currently, Profound UI understands JPEG and PNG type pictures.
This support is provided by the following properties:
- blob table - this specifies the database table (sometimes called "file") that contains the BLOB column.
- blob column - the name of the column ("field") that contains the BLOB.
- blob selection criteria - controls which row ("record") is selected. For best performance, we recommend using a selection criteria that returns only one row.
- blob parameter value - values of any parameters in the selection criteria. If there are no parameters, this property is not used.
Behind the scenes, Profound UI will use these fields to generate an SQL statement that is used to read the BLOB. The SQL statement will be built as follows:
select BLOB-COLUMN from BLOB-TABLE where BLOB-SELECTION-CRITERIA
lkkljk