OraFAQ Forum: Forms » Not allow duplicate values for an item

Home » Developer & Programmer » Forms » Not allow duplicate values for an item

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

Not allow duplicate values for an item [message #286734]

Mon, 10 December 2007 00:57

subhash.pophale
Messages: 9
Registered: December 2007
Location: Mumbai

Junior Member

Hi,
My form contains tabbular layout with two field
1):acc_poa_mapping.hold_ind and 2):acc_poa_mapping.holder_nm

I want to restrict duplicate values for item HOLD_IND without saving them to database. Also I don't want change property,I have to do it using some code in form provided trigger.

Waiting for your solutions....

Thanks

Report message to a moderator

Re: Not allow duplicate values for an item [message #286740 is a reply to message #286734]

Mon, 10 December 2007 01:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Here's one way (silly as it is):
- Copy all the item values to an array.
- In the when-validate-item, check whether the value the user has entered is in the array.
- If it is: raise an error, if it isn't, add it to the array.

Why are you reluctant to fiddle with properties?

MHE

Report message to a moderator

Re: Not allow duplicate values for an item [message #286756 is a reply to message #286734]

Mon, 10 December 2007 01:33

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear for this you have to create an array with these two columns and populate it when you perform execute query on your base table block.

Now on runtime on Pre-Record check the current record's value with your array records.

The Base Table current record number and Array's index no. will help you in checking that which record you are analyzing.

Regards,
Azam Khan

Report message to a moderator

Re: Not allow duplicate values for an item [message #286764 is a reply to message #286756]

Mon, 10 December 2007 01:39

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A great! I got myself an echo Very Happy

.

@azamkhan: check my post. What did I write?

I think a PRE-RECORD is not the correct place to check for duplicate values.

MHE

Report message to a moderator

Previous Topic:	codinig for Execute_query button
Next Topic:	Messaging problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 03:26:32 CST 2025