Database Tour Documentation Contents Index

Blob Fields

Top Previous Next

When your active table (or query) includes BLOB fields (fields with large text data (Memo), RTF data, OLE data, graphics etc), you can use Blob Editor to work with such data. To activate the blob editor double-click the corresponding column or choose Tools | Blob Editor.

The Blob Editor consists of several pages for working with different kinds of blob data.

blob

Memo (text) and RTF data

To work with blob fields, which consist of text data, use page As Text (for plain text) or As RTF (for formatted text).

You can edit the contents of MEMO-fields of the active data set. There are functions to print, load from a file and save to a file the contents of such fields.

Graphic data

To work with blob fields, which consist of graphic data, use page As Picture. There are several formats supported (BMP, ICO, EMF, WMF, JPEG, PNG, GIF).

You can view and edit the contents of the graphic fields of the active data set.

If Stretch option is checked then picture size will be automatically resized to fill out its window (you can resize this window), otherwise the picture is shown in its real size.

There is ability to load pictures from BMP, ICO, WMF, EMF, PNG, GIF, or JPEG files to the database.

You can save the graphic contents of the blob fields to a file.

You can copy the graphic images from one field or record to another one (or from this program to another one and vice versa) by using clipboard.

You may print the contents of the graphic fields. There are three modes of graphic printing:

-Screen millimeters = paper millimeters - picture size does not change; this mode is sensitive to the system resources for big pictures and if the printer resolution much greater than the screen resolution (as in laser printers);
-Fit to page with proportions - picture is resized to paper size, but proportions are saved; this mode is sensitive to the system resources, if the printer resolution much greater than the screen resolution (as in laser printers);
-Screen pixels = printer pixels - picture size may be very small, if the printer resolution much greater than the screen resolution (as in laser printers), but printing executes faster.

Other data

When the blob data is not text, formatted text or graphics in the formats, noted above, you should use As Hex page. You cannot edit such data directly, but it is possible to load the data from file or save the field data to file.