Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 9/26/2008
For: Version 2.01 Build 5
# 2813 UNIQUE Constraints Not Being Enforced Properly When NULLs Present in Constraint Columns

I have a table with a unique constraint:


I also have three identical records:

_fkProjects = 3
_fkContacts = NULL
_fkCompanies = 100016
_fkSites = 0

Resolution Resolution
Fixed Problem on 9/27/2008 in version 2.02 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