OraFAQ Forum: Forms » Check for duplicate value in grid for non database block

Home » Developer & Programmer » Forms » Check for duplicate value in grid for non database block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check for duplicate value in grid for non database block [message #365212]

Thu, 11 December 2008 02:20

pankajhonrao
Messages: 1
Registered: November 2008

Junior Member

Sir
i have non database block. and in that i do not want to accept the duplicate value in id field.If user enter the duplicate value i want to give the message immediately.Is any trigger is available to check the duplicate value

Report message to a moderator

Re: Check for duplicate value in grid for non database block [message #365221 is a reply to message #365212]

Thu, 11 December 2008 02:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a unique or primary key constraint.

Regards
Michel

Report message to a moderator

Re: Check for duplicate value in grid for non database block [message #365223 is a reply to message #365212]

Thu, 11 December 2008 02:49

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

The best way I ever found of enforcing this was to create a record group, and add/remove the key value to the group as you create/delete records.
This allows you to check for the key value already existing before you create a new record.

Report message to a moderator

Re: Check for duplicate value in grid for non database block [message #375811 is a reply to message #365223]

Mon, 15 December 2008 00:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Remember that this solution only works for a single user. You do need to use a primary key when there are multiple users.

David

Report message to a moderator

Previous Topic:	List item on my form, that gives me the files of a directory
Next Topic:	FRM-41042: Cannot create Group REC - Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:01:23 CST 2024