Reported By: Arnd Baranowski Reported On: 1/6/2003 For: Version 3.21 Build 1
# 1294Wrong 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
ResolutionCould Not Reproduce Problem on in version 0.00 build 1