Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 2/8/1999
For: Version 1.09 Build 1
# 285 UPPER and LOWER Functions in SQL Causing Access Violations

I'd still like to see a database or query level IgnoreCaseInSQL setting (just for filters). But failing that, I tried the above technique, but the following SQL:

SELECT t2.FileID, t1.FirstName, t1.LastName
FROM people t1, claims t2 WHERE t1.PeopleID = t2.PeopleID
AND UPPER (FirstName) LIKE "C%"

gives an Access Violation in Delphi and DBSYS.

Comments Comments
Both the upper and lower function were trying to evaluate arguments that did not exist.

Resolution Resolution
Fixed Problem on 2/8/1999 in version 1.10 build 1