Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Unique |
Sat, May 23 2009 11:17 PM | Permanent Link |
Charalampos Michael | Hello,
Any ideas how to set a field to have/accept unique values ? (iow, not to allow duplicate values) -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Sun, May 24 2009 3:10 AM | Permanent Link |
Ulrich Becker | Michael,
> Any ideas how to set a field to have/accept unique values ? > (iow, not to allow duplicate values) You should create a constraint on the field and setting its type to unique. Uli |
Mon, May 25 2009 6:13 PM | Permanent Link |
Charalampos Michael | Dear Ulrich,
> >> Any ideas how to set a field to have/accept unique values ? >> (iow, not to allow duplicate values) > > You should create a constraint on the field and setting its type to unique. I already did that but when i add a new record it allowed the duplicate value!! (that's the reason i asked) Field1 = Integer -> Default Value = 0 I have the constraint set to unique for Field1. Append; Post; Append; Post; Now i have 2 records with the value of Field1 = 0 -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Tue, May 26 2009 1:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< I already did that but when i add a new record it allowed the duplicate value!! (that's the reason i asked) >> I just tried the same thing here in the EDB Manager (B13) and it seems to work just fine. CREATE TABLE "TestDuplicate" ( "Field1" INTEGER DEFAULT 0, CONSTRAINT "Field1" UNIQUE ("Field1") ) -- Tim Young Elevate Software www.elevatesoft.com |
Tue, May 26 2009 6:34 PM | Permanent Link |
Charalampos Michael | Tim Young [Elevate Software] wrote:
> Michael, > > << I already did that but when i add a new record it allowed the duplicate > value!! (that's the reason i asked) >> > > I just tried the same thing here in the EDB Manager (B13) and it seems to > work just fine. > > CREATE TABLE "TestDuplicate" > ( > "Field1" INTEGER DEFAULT 0, > CONSTRAINT "Field1" UNIQUE ("Field1") > ) > Did you try to append & post more than once without changing the value of "Field1" ? -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Thu, May 28 2009 3:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Did you try to append & post more than once without changing the value of "Field1" ? >> Yes, absolutely. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 28 2009 6:41 PM | Permanent Link |
Charalampos Michael | Dear Tim,
> << Did you try to append & post more than once without changing the value of > "Field1" ? >> > > Yes, absolutely. Hmm, Or i do something wrong or i do something wrong ? I'll check it again and send you the tables. -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Fri, May 29 2009 3:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Hmm, Or i do something wrong or i do something wrong ? I'll check it again and send you the tables. >> Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |