Icon View Incident Report

Serious Serious
Reported By: Jason
Reported On: 10/9/2004
For: Version 4.12 Build 1
# 1869 Using Update Triggers on a Table with a BLOB Field Can Cause Blob Corruption

Using the following code I cannot edit a memo field that is hooked up to a TDBMemo on a form. The memo contents revert back to their previous value whenever they are edited. Notice that nothing is actually happening in the trigger event handlers.

procedure TForm1.DBISAMEngine1BeforeUpdateTrigger(Sender: TObject;
  TriggerSession: TDBISAMSession; TriggerDatabase: TDBISAMDatabase;
  const TableName: String; CurrentRecord: TDBISAMRecord);
begin
  //
end;

procedure TForm1.DBISAMEngine1AfterUpdateTrigger(Sender: TObject;
  TriggerSession: TDBISAMSession; TriggerDatabase: TDBISAMDatabase;
  const TableName: String; CurrentRecord: TDBISAMRecord);
begin
  //
end;



Comments Comments
The triggers were not handling the copying of edited BLOB fields correctly, and this would result in a recursive BLOB pointer after for the BLOB field after the edit. A repair will fix the issue.


Resolution Resolution
Fixed Problem on 10/12/2004 in version 4.13 build 1
Image