Home » Developer & Programmer » Forms » duplicate records
duplicate records [message #77886] Sat, 08 December 2001 00:50 Go to next message
chandrakanth
Messages: 16
Registered: October 2001
Junior Member
how to check the duplicate unique field before inserting / updating and trape the error message to user named trigger ?

----------------------------------------------------------------------
Re: duplicate records [message #77893 is a reply to message #77886] Mon, 10 December 2001 08:37 Go to previous message
Surendra K
Messages: 8
Registered: September 2000
Junior Member
Hi Chandrakanth,

While inserting use DUP_VAL_ON_INDEX exception. If there is any duplicate record getting inserted it will raise this exception and you can code your own logic here.

During inserting if this is taken care then there is no quesiton of having duplicate records while updating.

I hope this will help you.
Cheers.
Surendra K

----------------------------------------------------------------------
Previous Topic: exe file
Next Topic: variable substitution
Goto Forum:
  


Current Time: Thu Mar 28 12:52:52 CDT 2024