Home » Developer & Programmer » Forms » Duplicate Record entry in the FORM BLOCK.
Duplicate Record entry in the FORM BLOCK. [message #348784] Wed, 17 September 2008 23:32 Go to next message
dev88
Messages: 15
Registered: September 2008
Location: SAN JOSE
Junior Member
Hi Gurus,

Please share you experience, if you come across a requirement below.

** I am developing a form where, have master detail relationship exists.
In the detail level a unique field combination should exists(Rules).

Rules:
Ex: Contract#| Item_name |Country | Begin_Date | End_Date
-------------------------------------------------------
(1) 123 | PHONE | US | 01-JAN-2008 | 01-JAN-2010
(2) 124 | CABLE | US | 01-JAN-2008 | 16-SEP-2008
(3) 124 | CABLE | US | 16-SEP-2008 | 16-OCT-2008

Up to this point it is working fine and good since i have defined unique index on (Item_id,Item_name,Country) at table level. So system is not allowing me to enter duplicate record.

Business requirement is : Entile record shold be non-updatable when, End_Date is less then sysdate.

Upto here it is fine and working good.

Here starts the issue, In a Scenario, if user want to define a new set of record with same combination thro
Begin and End Dates are different(as Line 3), system is not allowing to create a record since unique index exists. Since Line(2) of combination exists already.


Please let me know how to handle this situation.

Thanks,
DD.

[Updated on: Wed, 17 September 2008 23:36]

Report message to a moderator

Re: Duplicate Record entry in the FORM BLOCK. [message #348813 is a reply to message #348784] Thu, 18 September 2008 00:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Change the unique index.

David
Previous Topic: global variable and execute query
Next Topic: What is the difference in varchar2
Goto Forum:
  


Current Time: Wed Dec 07 05:00:37 CST 2016

Total time taken to generate the page: 0.08774 seconds