vishal_singh
asked on
List Values behaving weirdly in Oracle Forms 9i
Hello Guys,
I have few list values, which are getting populated from a record group. I put this code in When-new-item-instance trigger(which populates).
Problem : When I run the form, then it shows a blank list having an initial value and blank value, and when I press the initial value which is 'All GL Class Codes' then it pops up the original list(which it should be).
I don't know why it is behaving like this. I have also shown it in the forms of screenshots (step-by-step).
Please help me out in this matter.
Thanks in advance,
Vishal
form6b.JPG
form6c.JPG
form6-property.JPG
I have few list values, which are getting populated from a record group. I put this code in When-new-item-instance trigger(which populates).
Problem : When I run the form, then it shows a blank list having an initial value and blank value, and when I press the initial value which is 'All GL Class Codes' then it pops up the original list(which it should be).
I don't know why it is behaving like this. I have also shown it in the forms of screenshots (step-by-step).
Please help me out in this matter.
Thanks in advance,
Vishal
Record Group Query:
select 'All GL Class Codes', 'All', 1
FROM DUAL
UNION
select distinct b.product_gl_class_desc, b.product_gl_class_cd, 2
from product_gl_class b
order by 3, 1
form6a.JPGform6b.JPG
form6c.JPG
form6-property.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.