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

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

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

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

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

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

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

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