View Incident Report

Minor

Reported By: Christian Sanggaard
Reported On: 1/4/2011
For: Version 4.30 Build 2

# 3401 Using LOWER() Function with Live Result Set Queries and Filters Can Cause Incorrect Results

If I execute this SQL script it returns the correct records that match the WHERE statement.

But if I activate the live result property the same sql statements returns no records.

select  No, GroupCode, Email, Category , name, phoneno2
from Customers
where (LCase(PhoneNo2) = LCase('63131413')) and
      (LCase(name) = LCase('Jelling.IT'))

Comments and Workarounds

The issue was with how DBISAM was handling the internal buffers for scanning the index. The workaround is to use UPPER()/UCASE() instead of LOWER()/LCASE().

Resolution

Fixed Problem on 3/14/2011 in version 4.30 build 3

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap