Skip to main content
Answer

How to avoid duplicate entry or make column unique

  • July 9, 2025
  • 2 replies
  • 31 views

Forum|alt.badge.img+1

Hello

 

I have below Supplier  data model

 

How can i prevent entering a duplicate value?

In the portal, it is designed to add, edit delete but it allows to enter duplicate data

 

I'm not sure how unique constraint works here but  I added an Indexes unique constraint but it doesn't work. Please advice

 

Below is the values on index column, unique is also ticked

Thanks in advance

Best answer by jkruter

I just so happen to be doing something similar today, and for me it is working as intended.

The only thing I can think of is that maybe you forgot to update your database (Creation > Generate definition > Generate source code > Execute source code)?

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+2
  • Vanguard
  • Answer
  • July 9, 2025

I just so happen to be doing something similar today, and for me it is working as intended.

The only thing I can think of is that maybe you forgot to update your database (Creation > Generate definition > Generate source code > Execute source code)?


Forum|alt.badge.img+1
  • Author
  • Vanguard
  • July 9, 2025

Hi Jkruter,

 

Thank you! yes for some reason after i repeat the deployment procedure and it works