?
Solved

oracle forms 6i, how to display data thru combo box

Posted on 2006-05-22
4
Medium Priority
?
5,732 Views
Last Modified: 2013-12-12
Hi,

I want to display a combo box on a form based on the field(based on a query) from the table. when the user selects a value, i call oracle reports and generate a report.

how do i do that??

I created a data block and added a list item with type combo box.but i keep getting this error..

FRM-30191: No list items defined for required poplist.
List listname
Item: ItemName

Thanks
0
Comment
Question by:Pra4444
2 Comments
 
LVL 2

Accepted Solution

by:
mirko-iras-si earned 200 total points
ID: 16759240
Try this:

First set the following values to the list:

List style: Poplist
Elements in list: add one element with value 'X'
Mapping of Other Values: X
Initial value: empty
Required: No

Then in the program (when-new-form-instance trigger):

DECLARE

  CURSOR c_report_list IS
    [your query with report descriptions and file names];
  i number := 1;

BEGIN

Clear_list ('report_list');

  for r in c_report_list loop
          Add_list_element ('report_list', i, r.description, r.filename);
          i := i+1;
  end loop;

Set_item_property ('report_list', REQUIRED, PROPERTY_TRUE);
-- Omit next line if you want the list to be initially empty
:report_list := get_list_element_value('report_list', 1);

END;

(I assume the poplist is called report_list)
0
 

Expert Comment

by:textoeditores
ID: 23077212
I have a form with 15 list item's (more or less), every one of them has a very fast query behind, and none of them reach more than 20 elements, they usually have around 9 elements.

My problem is: the form is too slow! is there any property I can set up in order to get the form faster?

Database blocks of the form are pretty new, and they are almost empty, it were supposed to be fast.

Thanks,
Renato.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month14 days, 11 hours left to enroll

840 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