I created a record group using create_group_from_query built-in whcih populates a column, if I tried to create one more record group with a different query it gives me error sayin "populate_list:invalid column type for column 1 FRM41335" ....Can't I use the populate_list built in twice in a form?How do u create 2 record groups(i.e 2 different query to populate 2 list item dynamically)using create_group_from_query builtin in the same trigger(when_new_form_instance).

The code goes like this...


DECLARE
QUERY RECORDGROUP;
QUERY_OK NUMBER;

BEGIN

QUERY:=CREATE_GROUP_FROM_QUERY('pay_date',
'SELECT pw_payin_date, pw_payin_date INTO
:FRM2.pw_payin_date FROM payin_withdrawal');
QUERY_OK:=POPULATE_GROUP(QUERY);
IF QUERY_OK <>0 THEN
RAISE FORM_TRIGGER_FAILURE;
ELSE
CLEAR_LIST('FRM2.PW_payin_date');
POPULATE_LIST('FRM2.PW_payin_date',QUERY);
END IF;

END;