Use of Validate From List Property [message #590548] |
Fri, 19 July 2013 04:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi,
What is the uses of "Validate From List" Property(Yes/No) in LOV's Properties..Can one please help me please and i searched in google ,but i am not getting..
Thanks&Regards,
Siva
|
|
|
|
Re: Use of Validate From List Property [message #590550 is a reply to message #590548] |
Fri, 19 July 2013 04:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Suppose you created a form based on Scott's EMP table. When you create a list of values which shows available department numbers (such as "select deptno, dname, loc from dept") and attach it to emp.deptno item, pressing LoV button shows departments 10, 20, 30 and 40.
If you set "Validate from list" property to "No", you are allowed to enter, for example, emp.deptno = 75 (unless there's a WHEN-VALIDATE-ITEM trigger which handles that invalid value (because deptno = 75 doesn't exist in DEPT table).
But, if you set "Validate from list" property to "Yes", then Forms automatically checks value you entered against values returned by a LOV, so it rejects an invalid deptno = 75 value.
|
|
|
|