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: 10181
Registered: March 2005
Location: Surges Bay TAS 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 06 16:50:20 CST 2024