Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 3/29/1999
For: Version 1.13 Build 1
# 393 Using Field to Field Comparisons in SQL WHERE Clause Causes Invalid Results to be Returned

The statement

SELECT * FROM Hearings WHERE Installments <> Installments

returns all the records in the file. It should return none of them, as the WHERE clause cannot possibly be true.


Resolution Resolution
Fixed Problem on 3/30/1999 in version 1.14 build 1
Image