View Incident Report

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

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap