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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:37:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.