I would like to add another keys to the table with unique constraint key. I've already added the primary key with BigInter Datatype.
I would like to add another keys to the table with unique constraint key. I've already added the primary key with BigInter Datatype.
Please can you share the code part or reference? Becuase I am fresher in Dynamic nav.
You cannot add a unique key, you need to add the code in the OnInsert Trigger of the table to check, or on the validate of that particular field.
Jganga,
In Navision you need to do this by code, for example in the validate trigger of the field.
If you add new keys you can use it for order the data but no for create unique constrain.
Best regards.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,645 Most Valuable Professional
nmaenpaa 101,148