| Use of Validate From List Property [message #590548] |
Fri, 19 July 2013 04:09  |
 |
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  |
 |
Littlefoot
Messages: 21808
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
