Solved

List Values behaving weirdly in Oracle Forms 9i

Posted on 2009-07-09
1
714 Views
Last Modified: 2013-12-19
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
Comment
Question by:vishal_singh
1 Comment
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
ID: 24818417
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 36 84
Identify records which do NOT qualify for a view 9 36
Clone Oracle 12c Database 5 43
Oracle query output question 4 36
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now