Icon View Incident Report

Serious Serious
Reported By: Pedro Miguel Martins
Reported On: 11/19/2003
For: Version 4.00 Build 1
# 1477 Using NULL in IF() Function in SQL SELECT Columns Causes Error

In Vrs 3 I use the following SQL, but in Vrs 4 I recevie an error:

Type mismatch between column 'OP.UserCloseID' and constant 'NULL' in source columns

 If (OP.UserCloseID=NULL, false, true) As Fechado
 From ObrasData OP
 where OP.ObrasID = 1

Resolution Resolution
Fixed Problem on 11/20/2003 in version 4.01 build 1