Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Creating pop-list from a column in a table, in Forms 4.0.

Creating pop-list from a column in a table, in Forms 4.0.

From: naheed <NAHEEDA_at_msmail1.ans.alcatel.co.uk>
Date: 1997/08/07
Message-ID: <01bca33a$b6d0d020$d3793ec2@naheed.abbas.ans.alcatel.co.uk>#1/1

I want to have the entries from a coloumn in a table populate a pop-list. It doesn't sound that difficult.......

  1. I've made a record group with two columns that are the same.
  2. I've placed a list down on the form.

I think i need to create a trigger to execute "populate_list", but all the triggers that I've tried have not worked. This is the layout of the trigger i have been using:

Declare

	list_id		Item := Find_Item('the_list');
	recgrp_id	RecordGroup := Find_Group('the_recgrp');
Begin
	do_key( 'Populate_List(list_id, recgrp_id)' );
End;

If I attach this text to a when-button-pressed trigger, in run-time i get the message:

                FRM-41004: Function key not allowed in this mode.

If I remove do_key from the trigger i get this message if i compile the text

                Error 313 Populate_list not declared in this scope.

So, how do i get the values form the record group into the pop-list?

Thanx, Nahaad's friend. Received on Thu Aug 07 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US