Icon View Incident Report

Serious Serious
Reported By: Horst-Henning Grosse
Reported On: 7/1/2009
For: Version 4.28 Build 4
# 3034 TEXTSEARCH Function Can Fail Sporadically in Delphi 2007 Applications

The following code finds "A-Kunde" but not "K-Kunde" in the table.



with TestTable do
begin
  Active := TRUE;
  Filter := 'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift1) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift2) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift3) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift4) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift5) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN PLZ) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift6) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Anschrift7) OR ' +
            'TEXTSEARCH(' + QuotedStr(Edit1.Text + '*') + ' IN Listfolge)';
   Filtered := TRUE;
   Refresh;

   showmessage(IntToStr(RecordCount) + ' Adresse(n) gefunden');

   Active := FALSE;
end;



Comments Comments
There is an issue with partial-length searches in Delphi 2007 due to an issue with how it is allocating and terminating strings vs. other versions of Delphi.


Resolution Resolution
Fixed Problem on 7/6/2009 in version 4.28 build 5


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image