Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 734
  • Last Modified:

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
0
vishal_singh
Asked:
vishal_singh
1 Solution
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now