Skip to main content
Solved

How to avoid duplicate entry or make column unique


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)?

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Rookie
  • 4 replies
  • 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
  • 43 replies
  • July 9, 2025

Hi Jkruter,

 

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings