Using OLE columns in a DataWindow object

You can create OLE columns in a DataWindow object. An OLE column allows you to:

  • Store blob (binary large-object) data, such as Microsoft Excel worksheets or Microsoft Word documents, in the database

  • Retrieve blob data from a database into a DataWindow object

  • Use an OLE server application, such as Microsoft Excel or Microsoft Word, to modify the data

  • Store the modified data back in the database

You can modify the document in the server, then update the data in the DataWindow object. When the database is updated, the OLE column, which contains the modified document, is stored in the database.

Database support for OLE columns

If your database supports a blob datatype, then you can implement OLE columns in a DataWindow object. The name of the datatype that supports blob data varies. For information on which datatypes your DBMS supports, see your DBMS documentation.