Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 12/3/2007
For: Version 1.06 Build 1
# 2493 Using a Parameterized Query With an Insensitive Result Set and Reading a BLOB Column Causes Hang

I'm working on creating my own internal table spec compare and restructure function for use within my own app. Everything is working great until I try to read the contents of a populated DefaultExpr field using FieldByName(<FieldName>).AsString. If all of the DefaultExpr values are empty for all the fields in the table, it runs through without any problems. But if I try to read the information after populating the DefaultExpr fields, it starts hanging when I read them back in.

If it matters, I'm using a TEDBQuery to retrieve the information from information.tables.

Q.SQL.Text := 'select * from information.tablecolumns
where tablename = :TableName';
Q.ParamByName('TableName').AsString := TableName;
Q.Open;
while (not Q.Eof) do begin
  DefaultExpr := Q.FieldByName('DefaultExpr').AsString;
  ShowMessage(Q.FieldByName('Name').AsString + ': ' + DefaultExpr);
  Q.Next;
  end;
Q.Close;



Resolution Resolution
Fixed Problem on 12/5/2007 in version 1.07 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image