Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 7/6/2000
For: Version 2.03 Build 1
# 590 SQL SELECT IN Operator Failing If Field Name and Search Term Are Identical

No records are returned an SQL SELECT query if the field name and the search term for an IN comparison are the same, it works with '=' though.

SELECT * FROM CUSTOMER WHERE Company IN("Company")



Resolution Resolution
Fixed Problem on 7/7/2000 in version 2.04 build 1
Image