View Incident Report

Serious

Reported By: Ricardo Oliveira
Reported On: 2/24/2005
For: Version 4.17 Build 1

# 1985 Using <> 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;

Comments

The 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.

Resolution

Fixed Problem on 2/28/2005 in version 4.18 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap