View Incident Report

Serious

Reported By: Trevor Davis
Reported On: 11/17/2003
For: Version 4.00 Build 1

# 1479 Executing 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)

Resolution

Fixed Problem on 11/17/2003 in version 4.01 build 1

More Support Options