Dear All,
I have an LOV which has few duplicate records .
E.g. Feild Ename has name SMITH repeated twice as I have two employees with Same name but different EMPNO.
Now when I execute query in my form & start to navigate from 1 record to another it Pop-up LOV & ask me to Select though my Empname is valid,as Validate from List is set to 'Yes'.
When user navigates to the record in which the value for above field is one among the dupliate values of LOV. In this case, even though the item is valid , LOV still pops up as soon as User navigates to that record. This un-necessory pop-up is a problem for me. If user clicks 'cancel' then it throws an error that invalid value for the field (even though the existing item in that field is a valid value from the list).
Is this a bug in LOV ?
I have few lenghty work arounds to stop this pop-up, but I want to know of there is any simple solution for this problem?
I have already used
SET_RECORD_PROPERTY
SYSTEM.CURSOR_RECORD,'block_name',STATUS,QUERY_STATUS);
set_item_property('ITEM_NAME',item_is_valid,property_true);
But it does not help.
Any help appreciated.
Please mark a copy of your reply to himanshu.bhardwaj@polaris.co.in.
Note: I am using Forms 6i & the forms are being used in Oracle Apps.
Thanks & Regards
Himanshu
I have an LOV which has few duplicate records .
E.g. Feild Ename has name SMITH repeated twice as I have two employees with Same name but different EMPNO.
Now when I execute query in my form & start to navigate from 1 record to another it Pop-up LOV & ask me to Select though my Empname is valid,as Validate from List is set to 'Yes'.
When user navigates to the record in which the value for above field is one among the dupliate values of LOV. In this case, even though the item is valid , LOV still pops up as soon as User navigates to that record. This un-necessory pop-up is a problem for me. If user clicks 'cancel' then it throws an error that invalid value for the field (even though the existing item in that field is a valid value from the list).
Is this a bug in LOV ?
I have few lenghty work arounds to stop this pop-up, but I want to know of there is any simple solution for this problem?
I have already used
SET_RECORD_PROPERTY
SYSTEM.CURSOR_RECORD,'block_name',STATUS,QUERY_STATUS); set_item_property('ITEM_NAME',item_is_valid,property_true);
But it does not help.
Any help appreciated.
Please mark a copy of your reply to himanshu.bhardwaj@polaris.co.in.
Note: I am using Forms 6i & the forms are being used in Oracle Apps.
Thanks & Regards
Himanshu