Database Binary/Text Large Object dialog box
Description
Specify characteristics of the Blob object you are inserting
into a DataWindow object.
Dialog options
-
Client Class
An optional value used by some OLE server applications for
the title that displays at the top of the server window. The default
is DataWindow. -
Client Name
An optional value used by some OLE server applications for
the title that displays at the top of the server window. -
Table
Select the database table that contains the large database
object you want to insert in the DataWindow. -
Large Binary/Text Columns
Select the column that contains the Blob data type.
-
Key Clause
Enter a key clause to build a valid WHERE clause. The key
clause is used to build the WHERE clause in the SELECT or UPDATE
statement for the OLE column. For example, if key_col is
the index on your table you might enter:1key_col = :rpt_id -
File template
Enter the name of the file you want to open in the OLE server
application. This value is optional unless more than one column
opens the same data. For example, if multiple columns open the same
Excel spreadsheet, you would enter the name of the .XLS file. -
OLE Class Description
Select a class from the dropdown list or enter it in the box.
-
Client Name Expression
Enter the text or an expression that can be evaluated in the
report (usually with a Key clause). This expression will display
in the server application to identify the file. For example:1"Document" + string(id)