Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

You can use any value for the blob properties that will be understood by the database.  For example, the BLOB selection criteria can have multiple ANDs and ORs, etc as would be appropriate in the database's WHERE clause.  Likewise, the blob table can contain a library, schema or database name that would be valid in the database FROM clause.

The SQL statement should return one column from one row.  If you attempt to provide multiple columns, you will get an error at runtime.  If you attempt to provide multiple rows, Profound UI will only use the first row returned and will ignore the others.  The SQL query will perform better, however, if you use the "blob selection criteria" to limit the output to a single row.