Hello all.
In a 6i form WBPressed trigger creates the parameter list
begin
v_paramlist_id := create_parameter_list('FRM_PARM_LIST');
add_parameter('FRM_PARM_LIST', 'P_CUST_NUM', TEXT_PARAMETER,
to_char(:CUSTOMER_INFO.CUST_NUM));
open_form('CUSTOM_SCORING', ACTIVATE, SESSION,
NO_SHARE_LIBRARY_DATA, 'FRM_PARM_LIST');
destroy_parameter_list('FRM_PARM_LIST');
end;
Then in the second form, WNFInstance trigger has:
if :PARAMETER.P_CUST_NUM is not null
then
GET_PARAMETER_ATTR('FRM_PARM_LIST', 'P_CUST_NUM', x, v_cust_num);
set_block_property('CUST_SCORING', DEFAULT_WHERE,
'CUST_NUM = to_number('||v_cust_num||')');
go_item('cust_scoring.cust_num');
do_key('execute_query');
I get FRM-40505 Unable to perform query. It was working, but I broke it along the way. Does this much seem correct to open the second form and query the specific customer?
Upon opening the second form in the Developer tool, it cannot locate a custom Object Library called PARAMETERS. I deleted it & drug it in again from the original (sub-classed). Sould I do the entire library?
Thanks.