Reported By: Ricardo Oliveira Reported On: 2/24/2005 For: Version 4.17 Build 1
# 1985Using <> Filter on a String Field in a Table Without the ANSI Standard Locale Could Hang Application I have a problem with DBISAM when filtering a query. I made a query like the following. Then i tried to filter it. The program just hangs when filtered:=true is called. I don't know if that matters but all the tables have locale set to Portuguese.
SELECT fieldname FROM TableName
(FieldName is a string)
filter:='fieldname<>''M''';
filtered:=true;
CommentsThe problem was caused by improper bumping of the ranges generated internally for scanning the appropriate index when executing an optimized filter. If there was not an index available for optimization, then this bug would not occur.
ResolutionFixed Problem on 2/28/2005 in version 4.18 build 1