Icon View Incident Report

Serious Serious
Reported By: Clive Bennett
Reported On: 6/4/2004
For: Version 4.07 Build 1
# 1749 SQL and Filter NOT IN Operator Not Working Properly

The following query does not return any rows.

select * from rpt_generic_detail
where scenario_code = 64 and
rowid not in (84,85)

Workaround:

select * from rpt_generic_detail
where scenario_code = 64 and
rowid <> 84 and rowid <> 85



Resolution Resolution
Fixed Problem on 6/5/2004 in version 4.08 build 1
Image