Icon View Incident Report

Serious Serious
Reported By: Grzegorz Rewucki
Reported On: 2/22/2005
For: Version 4.17 Build 1
# 1984 Accessing a BLOB Column From Within a Trigger in the Database Server Causes #9998 Blob Offset Error

I found a bug in accessing blob fields data inside before insert/update triggers. Both examples below raise exception: 9998 Invalid BLOB offset into ...when MemoField is modified. The triggers are defined in the database server.

1) Str := CurrentRecord.FieldByName('MemoField').AsString;
2) Stream := CurrentRecord.CreateBlobStream(MemoField, bmRead);

Comments Comments
This only occurs when the trigger is executing within the database server (TDBISAMEngine.EngineType=etServer). It does not occur with local triggers (EngineType=etClient).

Resolution Resolution
Fixed Problem on 3/4/2005 in version 4.18 build 1