Specifications

Using OLE columns in a report
500 InfoMaker
3 In the Table box, select the database table that contains the blob database
column you want to place in the report.
The names of the columns in the selected table display in the Large
Binary/Text Columns list.
4 In the Large Binary/Text Columns box, select the column that contains the
blob datatype from the list.
5 If necessary, change the default key clause in the Key Clause box.
InfoMaker uses the key clause to build the
WHERE clause of the SELECT
statement used to retrieve and update the blob column in the database. It
can be any valid
WHERE clause.
Use colon variables to specify report columns. For example, if you enter
this key clause:
id = :id
the WHERE clause will be:
WHERE id = :id
6 Identify the OLE server application by doing one of the following:
• If you always want to open the same file in the OLE server
application, enter the name of the file in the File Template box.
For example, to specify a particular Microsoft Word document, enter
the name of the DOC file. If the file is not on the current path, enter
the fully qualified name.
Use the Browse button to find the file
If you do not know the name of the file you want to use, click the
Browse button to display a list of available files. Select the file you
want from the resulting window.
• If you do not want to open the same file each time, select an OLE
server application from the OLE Class: Description drop-down list.
When the server does not match the OLE blob data
If you specify a server that does not match the OLE blob object or if
your database contains objects belonging to different servers, the
OLE mechanism can usually handle the situation. It looks for the
server specified in the object and starts it instead of the server you
specified.