Icon View Incident Report

Serious Serious
Reported By: Scott Rowat [CommonGoals Software]
Reported On: 3/7/2013
For: Version 4.34 Build 7
# 3728 64-bit DBISAM Database Server Can Cause Field Not Found Error When Using Locate on Live Query

When using the 64bit server and setting the DBISAMQuery.RequestLive = True and doing a Locate causes DBISAM error saying the field is not found.

If the 32bit server is used the Locate works and no error is raised.

Query:
SELECT SubdivisionCode, SubdivisionName, IsDefault
FROM CountrySubdivisions
WHERE CountryCode = :CountryCode


procedure TForm1.Button1Click(Sender: TObject);
begin
  DBISAMQuery1.Close;
  DBISAMQuery1.ParamByName('CountryCode').AsString := 'CA';
  DBISAMQuery1.RequestLive := True;  //if false no error raised
  DBISAMQuery1.Open;

     if DBISAMQuery1.locate('IsDefault',True,[]) then
       showmessage('Yes')
     else
       showmessage('No');

  DBISAMQuery1.Close
end;



Resolution Resolution
Fixed Problem on 3/7/2013 in version 4.35 build 2


Products Affected Products Affected
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image