OraFAQ Forum: Forms » Text item Validation with LOV

Home » Developer & Programmer » Forms » Text item Validation with LOV (forms10)

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

Text item Validation with LOV [message #640809]

Wed, 05 August 2015 07:30

sanodani
Messages: 98
Registered: October 2014

Member

Hallo,

How can we check Validation of text_item with the LOV?
I have one text_item1, where i have to display ID and the next field with Address, and i have LOV in the item_text1, when i press F9 at runtime, it will select and display the respected value in both fields, but i would like to check Validation in item_text1, when user give the wrong ID, which is not in the LOV then should Display error.

Can anyone please help me?

thanking u

Report message to a moderator

Re: Text item Validation with LOV [message #640816 is a reply to message #640809]

Wed, 05 August 2015 08:18

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

Senior Member

what's wrong with just using validate_from_list?

Report message to a moderator

Re: Text item Validation with LOV [message #640820 is a reply to message #640816]

Wed, 05 August 2015 08:25

sanodani
Messages: 98
Registered: October 2014

Member

Hallo CM.

Thank you very much for your Suggestion.. yes i also did the same and it works Smile

validate_from_list = yes

Report message to a moderator

Re: Text item Validation with LOV [message #640832 is a reply to message #640820]

Wed, 05 August 2015 09:43

sanodani
Messages: 98
Registered: October 2014

Member

I have two blocks, and when i press F7 key in current block, (where already other records are displayed), it will insert new blank row below that. And that i want to avoid it.

is it possible to write some Trigger or do something, when i press F7 key, it should not allow to insert row, i use this block just to Show records, not to insert any..

help please Smile

thankx

Report message to a moderator