Specifications

Using OLE columns in a report
498 InfoMaker
Using OLE columns in a report
You can create OLE columns in a report. An OLE column allows you to
retrieve blob (binary large-object) data from a database into a report.
Database support for OLE columns
If your database supports a blob datatype, then you can implement OLE
columns in a report. The name of the datatype that supports blob data varies.
For information on which datatypes your DBMS supports, see your DBMS
documentation.
Creating an OLE column
This section describes how to create an OLE column in a report. The steps are
illustrated using a table that you can create in the Database painter. It must
contain at least two columns,
id and object:
•The
id column is an integer and serves as the table’s key.
•The
object column is a blob datatype and contains OLE objects associated
with several OLE servers.
❖ To create the database table:
1 In the Database painter, create a table to hold the blob (binary large-object)
data.
The table must have at least two columns: a key column and a column with
the
blob datatype. The actual datatype you choose depends on your DBMS.
For example, in SQL Anywhere, choose long binary as the datatype for the
blob column. For information about datatypes, see your DBMS
documentation.
2 Define the blob columns as allowing
NULLs (this allows you to store a row
that does not contain a blob).
Adding a blob column
to the report
The following procedure describes how to add a blob column to a report.
❖ To add a blob column to a new report:
1 Create a new report.