Icon View Incident Report

Serious Serious
Reported By: Rick Hillier
Reported On: 2/24/2003
For: Version 3.17 Build 1
# 1312 Using a BLOB Field in an OnFilterRecord Event and Editing Same Blob Causes Invalid Handle Error

One of the beta testers of my program sent me this error report:

I brought up the Edit File Comments for Blank Comments, and selected a file. I added a comment, then clicked on the button to popup the categories, and clicked on a category and clicked "Select Category". When I click on another file, it pop's up an error:

DBISAM Engine Error # 10030 Invalid blob handle for the table 'Misc_CAT' specified.

It seems to save fine, but an error is of course, an error. The documentation says that this error should not occur and that I should be contacting you if it does... The code is straight forward - saving a comment to a blob field.

procedure TForm1.CatalogTableFilterRecord(DataSet: TDataSet;
  var Accept: Boolean);
  This is in the actual program - I have a filter set to allow them to 
  records in their catalog that have a blank comment and edit those 
comments.  If
  they add a comment, it would disappear from the list, so I save a 
list of pointers
  to a reasonable extent so that the edited records will remain in the 

  I still get the error message with either statement.

  Accept := ((Trim(CatalogTable.FieldByName('Comment').AsString) = '') 
or in_pointerarray(CatalogTable.FieldByName('Tag').AsInteger));
  Accept := (Trim(CatalogTable.FieldByName('Comment').AsString) = '');

Resolution Resolution
Fixed Problem on 2/28/2003 in version 3.22 build 1