View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap