PDA

View Full Version : Repopulation of List Items in a Data Block - Forms 6i, OEE 8.1.7


Jan Gelbrich
06-14-2004, 05:38 AM
Hello,

I have problems with repopulation of List Items.
For tests I made a very simple Form containing only 1 data block, with items
id[Number], testvalue1, testvalue2[both varchar2]. The block is built using
the wizards.

Then, I changed the 2 items Testvalue1 and Testvalue2 into
List Items, to be filled with Record Groups G1 and G2.

List1(<-Group G1) works well as expected, but
the goal of this test is List2 depending on it:
can List2 be repopulated due to selection of List1
(using a WHEN-LIST-CHANGED trigger, that fires the following PU:

PROCEDURE PU_RePopulate_G2 IS

I Number := 0;
Az Number;
List_Id Item;
Rg_Id Recordgroup;

BEGIN

Rg_Id := Find_Group('G2');

--First try .......................
If Not Id_Null(Rg_Id)
Then
Delete_Group(Rg_Id);
End If;
Rg_Id := Create_Group_From_Query('G2',
'Select value2, To_Char(Id) ' ||
'From jg_g2 '--||
'Where value1 = :Jg_Testtab.Testvalue1 '||
'Order By value1'
);

--gives errors:
-- FRM-41072: ....
-- FRM-41331: ....
--(I did RTFM, but did not know what to do against it ...)


--Alternative try .............................
Az := Populate_Group_With_Query( Rg_Id,
'Select value2, To_Char(Id) ' ||
'From jg_g2 '--||
'Where value1 = :Jg_Testtab.Testvalue1 '||
'Order By value1'
);

--gives errors:
-- FRM-41076: ....

-- - - - - - - - - - - - - - - -
List_Id := Find_Item( 'JG_Testtab.Testvalue2' );
Clear_List( List_Id );
-- Az := Populate_Group( Rg_Id ); only with first try
Populate_List( List_Id, Rg_Id );

END;


Is it possible to build
a chain of conditionally refilled list items *at all* ?
Or is it impossible in a data block ?
In control blocks, it can be done ...


I would appreciate any comments,
Thank You in advance.

Jan
Forms 6i, OEE 8.1.7, Windows Clients.

Jan Gelbrich
06-21-2004, 02:51 AM
OK, no answer indicates that nobody bothered - same on OTN ... so well.
I have a work around with LOVs instead (they can be chained).
But it would have been interesting if somebody would have had
another solution

Greetings, Jan


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service