Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Unique constraints
Fri, Sep 26 2008 1:45 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I have a table with a unique constraint

_fkProjects
_fkContacts
_fkCompanies
_fkSites

I also have three identical records

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



Roy Lambert
Fri, Sep 26 2008 1:59 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I also have three identical records >>

It's due to this fix:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.01&type=f&incident=2764

I'll have a fix for this in 2.02.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Sep 26 2008 2:55 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


Just checking - that says primary key not unique constraint.


Roy Lambert
Sat, Sep 27 2008 9:43 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Just checking - that says primary key not unique constraint. >>

Yes, but that change to the primary key behavior broke the unique
constraints.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image