Home » Developer & Programmer » Forms » duplication check
duplication check [message #205480] Sat, 25 November 2006 02:10 Go to next message
shubhanawale
Messages: 2
Registered: November 2006
Junior Member
Hi
I want the code for checking duplications for some fields
in block (which should written on when_validate_item trigger
of that field)



Thanks (In advance)
shubhangi.
Re: duplication check [message #205597 is a reply to message #205480] Sun, 26 November 2006 11:54 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
send ur .fmb with the problem details ...

Ashu
Re: duplication check [message #205633 is a reply to message #205480] Sun, 26 November 2006 22:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If the field is a primary key then search this forum for 'primary key'. There are Forms builtins to prevent duplicates in primary keys.

If the field is NOT a primary key then search this forum for 'record group duplicate' see example http://www.orafaq.com/forum/m/147598/67467/?srch=record+group+duplicate#msg_147598

David
Previous Topic: check box making problem Urgent please
Next Topic: Want to print Chart Item in Forms 6i
Goto Forum:
  


Current Time: Fri Dec 09 04:03:59 CST 2016

Total time taken to generate the page: 0.09416 seconds