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
vishal_singhAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flow01Commented:
If your suppliers list doen't change  every minute , try populating in the when_new_form_instance.

May be the when-new_item_instance fires when just when you press the item first time.
Is your cursor somewhere else when you enter the page ?

 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.