Link to home
Start Free TrialLog in
Avatar of vishal_singh
vishal_singhFlag for United States of America

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
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

Open in new window

form6a.JPG
form6b.JPG
form6c.JPG
form6-property.JPG
ASKER CERTIFIED SOLUTION
Avatar of flow01
flow01
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial