Icon View Incident Report

Serious Serious
Reported By: Arnd Baranowski
Reported On: 1/6/2003
For: Version 3.21 Build 1
# 1294 Wrong Results with Parameters in SQL WHERE Clause

The following use of parameters on an indexed integer filed in a WHERE Clause leads to wrong results:
"WHERE ((Flag_Owner = -1) or (Flag_Owner = :AnFlagOwner))"
or
"WHERE ((Flag_Owner = :AnFlagOwner1) or (Flag_Owner = :AnFlagOwner2))"

Using
"WHERE ((Flag_Owner = -1) or (Flag_Owner = 1))"
returns the correct result

See above



Resolution Resolution
Could Not Reproduce Problem on in version 0.00 build 1
Image