Check Duplicate Values [message #614397] |
Wed, 21 May 2014 05:44 |
Xandot
Messages: 235 Registered: January 2014 Location: India
|
Senior Member |
|
|
Hello all,
I want to create a validation to the items here i have one column like "Component Name"
if the user put the name of component and if its already into the DB so i want to restrict that duplicate entry.
I am not want to create unique key because already some duplicate values are there and user don't want to delete
previous data so please tell me how can i do this.
So how can i create this validation in my form.
Thanks
|
|
|
|
Re: Check Duplicate Values [message #614405 is a reply to message #614404] |
Wed, 21 May 2014 07:16 |
Xandot
Messages: 235 Registered: January 2014 Location: India
|
Senior Member |
|
|
OK thanks Littlefoot for teaching me that...
Its working correctly ..
Can i give any message when user create a duplicate entry because now it raise error so user can't understand it ...
|
|
|
|
|
|
|
|
Re: Check Duplicate Values [message #614574 is a reply to message #614427] |
Fri, 23 May 2014 07:53 |
Xandot
Messages: 235 Registered: January 2014 Location: India
|
Senior Member |
|
|
@michel cadot :-- same is point to the ..
"Can i give any message when user create a duplicate entry because now it raise error so user can't understand it ..."
|
|
|