Icon View Incident Report

Minor 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 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 Resolution
Fixed Problem on 3/14/2011 in version 4.30 build 3


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
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