BLOB

Property
dbBLOB

When the selected fields in the Connection form contains is of BLOB type (72, 128, 204, 205). These fields will be placed in the "BLOB Flds" list box of this form automatically. Start building the dbBLOB properties by selecting the "BLOB Flds" and fill in the keywords.

• If "image/bmp" is selected and the "Replacement Text" is "Browser" (In-cell display) and the DBType is "Access" then the Offset of 78 is automatically supplied assuming as it is the BOLB Object offset for BMP files. This in-cell display works only in IE.
• Width and Height keywords are used in the <IMG> tag. Also note that specifying one of them will force the other to scale accordingly.
• Left click the Rest button will clear all the input boxes above the button while a right click of the Reset button will clear the dbBLOB text box.
• You can manually modify the dbBLOB text box to make change.
• MS-SQL and ORACLE BLOB fields are user controllable hence user can control the header of the BLOB.

BLOB Field
FieldNameOrNumber is the Database’s field that is of  BLOB type (72, 128, 204, 205). These fields are extracted from the actual display list.

Context Type
The HTML context type (image/jpg, image/bmp, image/gif, application/msexcel etc.)  These can be found in your browser’s “Helper Apps”). 

Replacement Text
This text will be displayed when Linked images are used instead of in-line images.

BLOB Offset
Every database implements BLOBs differently. When binary objects are stored in the data field with an attached header, you must determine how many bytes (if any) are delivered in front of the actual binary data.  Some examples are:

• ACCESS OLE-OBJ field containing BMP images – Offset = 78 (NWIND Employee Table example)

• Borland Paradox’s BLOB field storing images (Biolife example) – Offset = 8

Width / Height
WIDTH and HEIGHT tags within the IMG tag.

Generates the dbBLOB property.

Left click to clear the above fields and right clear will clear the properties panel.