Icon View Incident Report

Serious Serious
Reported By: Jirayu Wiriyaphibool
Reported On: 3/1/2001
For: Version 2.07 Build 1
# 731 #9494 Too Many Blobs Opened Error On Canned Result Sets and with RestructureTable and OptimizeTable

The following code will cause an #9494 Too Many Blobs Open error. The result set is not live.

procedure TForm1.SpeedButton1Click(Sender: TObject);
begin
  Qry.Close;
  Qry.SQL.Clear;
  Qry.SQL.Add(
  'SELECT CONTLIST.DATE, CONTLIST.TIME, CUSTCON.CUSTOMER_NAME, CONTLIST.DISCUSSION, CONTLIST.CONTACT,'+
  'CONTLIST.COMMENT FROM CUSTCON LEFT OUTER JOIN CONTLIST ON (CUSTCON.CUSTOMER_ID = CONTLIST.CUSTOMER_ID)'+
  ' ORDER BY CONTLIST.DATE, CONTLIST.TIME');
  Qry.Open;
  dbmemo1.datafield := 'DISCUSSION';
end;



Comments Comments
This issue also affects RestructureTable, OptimizeTable, CopyTable, and several other methods. If you are using BLOB fields in your application you should *not* use 2.07 and instead should go directly to using 2.08. THIS IS A SERIOUS ISSUE AND CAN POTENTIALLY CAUSE DATA CORRUPTION


Resolution Resolution
Fixed Problem on 3/2/2001 in version 2.08 build 1
Image