Home » Developer & Programmer » Forms » validate-from-list propery (oracle Version 10.1.2.0.2 , windows7)
validate-from-list propery [message #544276] Tue, 21 February 2012 00:56 Go to next message
7anona
Messages: 57
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
Re: validate-from-list propery [message #544308 is a reply to message #544276] Tue, 21 February 2012 03:29 Go to previous messageGo to next message
cookiemonster
Messages: 10852
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
Re: validate-from-list propery [message #544318 is a reply to message #544308] Tue, 21 February 2012 03:59 Go to previous messageGo to next message
7anona
Messages: 57
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
Re: validate-from-list propery [message #544322 is a reply to message #544318] Tue, 21 February 2012 04:03 Go to previous messageGo to next message
cookiemonster
Messages: 10852
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.
Re: validate-from-list property [message #544453 is a reply to message #544322] Tue, 21 February 2012 22:12 Go to previous messageGo to next message
7anona
Messages: 57
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
Re: validate-from-list property [message #544506 is a reply to message #544453] Wed, 22 February 2012 02:36 Go to previous messageGo to next message
cookiemonster
Messages: 10852
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you got the selected columns the opposite way round in each LOV?
Re: validate-from-list property [message #544514 is a reply to message #544506] Wed, 22 February 2012 03:09 Go to previous messageGo to next message
7anona
Messages: 57
Registered: February 2012
Member
yeS
Re: validate-from-list property [message #544516 is a reply to message #544514] Wed, 22 February 2012 03:21 Go to previous messageGo to next message
7anona
Messages: 57
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
Re: validate-from-list property [message #544517 is a reply to message #544516] Wed, 22 February 2012 03:45 Go to previous message
cookiemonster
Messages: 10852
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.
Previous Topic: Master / Detail Forms Issue
Next Topic: Serial Communication and Forms
Goto Forum:
  


Current Time: Tue Jul 29 12:26:27 CDT 2014

Total time taken to generate the page: 0.12214 seconds