-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|