Reported By: Trevor Davis Reported On: 11/17/2003 For: Version 4.00 Build 1
# 1479Executing an SQL SELECT COUNT(*) Query with a WHERE Clause Returns Incorrect Results The following SQL isn't using the WHERE clause in V4, but worked OK in v3. I get 34 when it should be zero.
SELECT COUNT(*) FROM JV
WHERE (Posted = false)
ResolutionFixed Problem on 11/17/2003 in version 4.01 build 1