About unique column

[yuta chiba]

Hi,mate.

I have questuion, About unique column.
I created original table.
It have "ip_address" column.
"ip_address" column have unique status, status is true.

But, ip_address duplexed.
Why, it duplexed.

Thank you.
yuta.

[Kalyani Jangam1]

Hi,

Personalize Dictionary for that field. If the Unique checkbox is not on the Dictionary form, personalize the form layout for the Dictionary form and add it. Check it for your field, and update the Dictionary record.

Then a unique constraint will be enforced for that field. Note that the field must not have duplicate values already, or doing what I described will fail.

[Hitoshi Ozawa]

Hi Yuta,

Add a unique index to the table.

1. Go to "System Definition" > " Tables & Columns"
2. Select the table to add index
3. Check "Unique Index" and select the column to make unique in the "Available" selection box
   
4. Click on "Create Index"

Execution result after adding unique index

[yuta chiba]

Hi Hitoshi-san,

Thank you for reply and advice.

I try it.

Sorry to ask about such minor details, What happens with this(Hitoshi-san advice) setting.

Is this not good enough?

※Below Image setting.

Thank you.

yuta.