OraFAQ Forum: Forms » validate-from-list propery

Home » Developer & Programmer » Forms » validate-from-list propery (oracle Version 10.1.2.0.2 , windows7)

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

validate-from-list propery [message #544276]

Tue, 21 February 2012 00:56

7anona
Messages: 72
Registered: February 2012

Member

hello every one,
I am having two items in my form. one of them is not a database item. i created a post-change trigger in both of them so when a value is typed (valid value from LOV) in one item the corresponding value appears in the other item when pressing tab, in both items the validate-from-list property is set to yes. the problem is when I type a valid value in one item LOV window pop-up as if I typed an invalid value

can any one help with this

Report message to a moderator

Re: validate-from-list propery [message #544308 is a reply to message #544276]

Tue, 21 February 2012 03:29

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

Senior Member

Do both items need to be enterable by the users?
If so you probably need to use two LOV's

Report message to a moderator

Re: validate-from-list propery [message #544318 is a reply to message #544308]

Tue, 21 February 2012 03:59

7anona
Messages: 72
Registered: February 2012

Member

yes, user should be able to enter in any of the two items. The LOV has two columns. every column will return a value in one of the items in my form. I didn't understand the use of the second LOV

Report message to a moderator

Re: validate-from-list propery [message #544322 is a reply to message #544318]

Tue, 21 February 2012 04:03

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

Senior Member

Validate from list is always done against the first column in the LOV.
So create two. One with the column for the first item first, and one with the column for the second item first.
Attach each to the appropriate item.

Report message to a moderator

Re: validate-from-list property [message #544453 is a reply to message #544322]

Tue, 21 February 2012 22:12

7anona
Messages: 72
Registered: February 2012

Member

I have created the second LOV and set the validate-from-list property of both items to yes but the problem is still there I don't know if I missed something from what you've suggested

Report message to a moderator

Re: validate-from-list property [message #544506 is a reply to message #544453]

Wed, 22 February 2012 02:36

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

Senior Member

Have you got the selected columns the opposite way round in each LOV?

Report message to a moderator

Re: validate-from-list property [message #544514 is a reply to message #544506]

Wed, 22 February 2012 03:09

7anona
Messages: 72
Registered: February 2012

Member

yeS

Report message to a moderator

Re: validate-from-list property [message #544516 is a reply to message #544514]

Wed, 22 February 2012 03:21

7anona
Messages: 72
Registered: February 2012

Member

it works fine when I set the property to NO. however,
my LOV now has 2 records while the main table has three records.(I want users to choose only between the two records)
by setting the property to NO, I suppose, the form would accept the third value.
is there a way to exclude the third record from beeing saved in the form

Report message to a moderator

Re: validate-from-list property [message #544517 is a reply to message #544516]

Wed, 22 February 2012 03:45

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

Senior Member

You could replicate the LOV validation in a when-validate-item trigger.
I'm not sure why my suggestion doesn't work, from memory it should, but I no longer have a working forms installation to test.
Hopefully someone else can check.

Report message to a moderator

Previous Topic:	Master / Detail Forms Issue
Next Topic:	Serial Communication and Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 03:51:56 CST 2025