Unique Constraint

Fisherman

Can anyone tell me how to issue a unique constraint (not a primary key - I have no natural key for a table that I have created, and instead want to use a surrogate). I have set it in SQL for that index (key), but I've discovered that the documentation shows that setting a unique key in SQL for fields other than the primary key may not work as expected...

Waldo

Well, actually, you have to do this in code (afaik) ... OnValidate of the field.

:-k

Fisherman

got it to work.

re-added my table, and added my primary key. Then I added a key on my columns that I wanted to make unique.

I then went into SQL Enterprise Manager, found the key that encompassed my fields, and set the index to a unique constraint.

Works great so far.

Waldo

What if you re-compile / do some minor changes to the table? Does the unique constraint keep existing, or does the NAV client reset the indexes?

Fisherman

I've recompiled twice since I built the original table, and it hasn't deleted it yet.

Waldo

OK, nice to know ... thanks!