Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 6/22/2008
For: Version 2.00 Build 2
# 2680 Using a Boolean Column by Itself in a WHERE Clause Expression Causes All Rows to be Selected

HasAttachments is a boolean. The following SQL selects ALL records regardless of the state of _HasAttachments.

select _HasAttachments from ELN where _HasAttachments



Comments Comments and Workarounds
This was only an issue with sensitive result sets. The workaround is to use an insensitive result set (RequestSensitive=False) or to use this alternative version of the query:

select _HasAttachments from ELN where _HasAttachments = TRUE



Resolution Resolution
Fixed Problem on 6/23/2008 in version 2.01 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image