Reported By: Oliver Wiechens Reported On: 3/10/2005 For: Version 4.17 Build 1
# 1971SQL WHERE Clause <> Comparison On Integer Field Returns Incorrect Results Running the following SQL Commands in a Query or in the DBSYS doesn't return all records:
select Artikel,ZuLiefern,ZuBerechnen from auftragpos
where (ZuBerechnen <> 0) and (ZuBerechnen is not null)
CommentsThe ZuBerechnen column was indexed in this case. This issue was very similar to other optimized <> conditions for other column data types in 4.17.
ResolutionFixed Problem on 3/10/2005 in version 4.18 build 1