View Incident Report

Serious

Reported By: Dominique Willems
Reported On: 2/6/2001
For: Version 2.06 Build 1

# 725 Using CopyOnAppend Property Can Cause BLOB Corruption After Append

I seem to get intermittent 8708 problems, after which a table repair results in "Invalid BLOB offset in BLOB file for physical record
#..., error fixed" messages for all records concerned.

The 8708 problems occur when a concerned table's field is referenced (read) after an edit and post, which itself comes after an insert operation (with CopyOnAppend). The table which is read is exactly the same dataset as the one where the insert and edit operations took place in.

procedure TForm1.Button1Click(Sender: TObject);
begin
  Data.Open;
  if Data.FindKey([3]) then begin
    Data.CopyOnAppend := true;
    Data.Insert;
    DataAnything.Value := 4;
    Data.Post;
    Data.CopyOnAppend := false
  end;

  if Data.FindKey([3]) then begin
    Data.Edit;
    DataAnything.Value := 5;
    Data.Post;
  end;
  Data.Close
end;

Resolution

Fixed Problem on 2/26/2001 in version 2.07 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap