Dynamic List Item Question
Date: Tue, 25 Feb 2003 00:11:06 GMT
Message-ID: <uwy6a.221827$SD6.11268_at_sccrnsc03>
Hey all,
I'm trying to make a block that has displays 10 records with 2 Fields. The
first item is a text item that SELECTs parent FROM parent_table. The Second
item is a LIST item that displays children FROM child_table WHERE parent is
the current parent for that Record. I've Got it to work fine for one
record, but
not for multiple records. Here is what I have so far...(this is in a
when-mouse-enter Trigger)
Any Help would be appreciated.
DECLARE
rg_id RECORDGROUP;
return_code NUMBER;
BEGIN rg_id := CREATE_GROUP_FROM_QUERY('RG_TEMP','SELECT child, child FROM child_table
WHERE parent = :FAMILY.PARENT ORDER BY 2');
return_code := POPULATE_GROUP(rg_id);
POPULATE_LIST('FAMILY.LST_CHILD','RG_TEMP');
DELETE_GROUP(rg_id);
END; Received on Tue Feb 25 2003 - 01:11:06 CET