OraFAQ Forum: Forms » Avoid the user to select twice the same value from LOV (merged)

Home » Developer & Programmer » Forms » Avoid the user to select twice the same value from LOV (merged)

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

Avoid the user to select twice the same value from LOV (merged) [message #472510]

Sat, 21 August 2010 05:16

manisha_borade
Messages: 49
Registered: May 2010

Member

hi,
i have created form. one field is there "Payment_terms" at line level. for that i created LOV containing 3 fixed Payment terms. my requirement is that Avoid the user to select twice the same value from LOV.

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #472512 is a reply to message #472510]

Sat, 21 August 2010 05:41

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

First Commit At Line Level after that you can validate it.

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479520 is a reply to message #472512]

Mon, 18 October 2010 03:34

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

loop through first record to last record and check for duplicates

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479523 is a reply to message #479520]

Mon, 18 October 2010 03:45

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

ranamirfan wrote on Sat, 21 August 2010 11:41

First Commit At Line Level after that you can validate it.

Or you could just post at line level. That way the users can still rollback changes.

athar.fitfd@hotmail.com wrote on Mon, 18 October 2010 09:34

loop through first record to last record and check for duplicates

In which trigger?

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479775 is a reply to message #479523]

Tue, 19 October 2010 05:08

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

Mr. CoookieMonsterr.

Do you know the trigger . When-Validate-Item

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479776 is a reply to message #479775]

Tue, 19 October 2010 05:10

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Try that in When-validate-item and you'll get errors.

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479777 is a reply to message #479776]

Tue, 19 October 2010 05:12

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

What are those errors

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479780 is a reply to message #479777]

Tue, 19 October 2010 05:19

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

illegal restricted procedure.

Report message to a moderator

Re: Avoid the user to select twice the same value from LOV [message #479785 is a reply to message #479780]

Tue, 19 October 2010 05:51

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

yor are right.

thanks

Report message to a moderator

Previous Topic:	problem of query in a procedure
Next Topic:	When Pressed F-11 & Ctrl F11 Buttons ,screen doesnt turn blue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 18:47:35 CST 2025