All
I have a Canvas Type = Tab.
On one of the Tabs I have a Data Block which has a procedure called within the WHEN-NEW-BLOCK-INSTANCE: -
POPULATE_TU_TYPE_LIST('TU_LIST.TU_TYPE');
EXECUTE_QUERY;
This is the procedure that is called: -
PROCEDURE POPULATE_TU_TYPE_LIST (ItemName VARCHAR2) IS
rg_name VARCHAR2(30);
rg_result number;
rg_list RECORDGROUP;
BEGIN
rg_name := 'RG_TU_TYPE_LIST';
rg_list := FIND_GROUP(rg_name);
IF NOT ID_NULL(rg_list) THEN
rg_result := POPULATE_GROUP(rg_list);
--CLEAR_LIST(ItemName);
POPULATE_LIST(ItemName, rg_name);
ELSE
MESSAGE('Failed to find RG : '||rg_name,NO_ACKNOWLEDGE);
END IF;
END;
This all works fine, the record group is populated, the query is executed and the data is displayed.
However, if I then switch to another Tab, EXECUTE_QUERY and then return to the original Tab, I receive the error "FRM-41337: Cannot populate the list from record group".
Is the only way to prevent this error by clearing the block before the EXECUTE_QUERY every time I return to the original tab or is there something else I haven't done / need to be doing?
Regards
Richard
Forms 12.2.1.0.0, Windows Server 2012 R2