Home » Developer & Programmer » Forms » Call_Form
Call_Form [message #362079] Sun, 30 November 2008 11:33 Go to next message
Goodspeed
Messages: 16
Registered: November 2008
Junior Member
Hello

I have two forms, first one have a multi record canvas. When i mouse double click in a record, i send this from form A to form B :

declare
pl_id paramlist;
Begin
if :pesquisa_geral.tipo = 'OFI' then
pl_id := create_parameter_list('list'); add_Parameter(pl_id,'docid',text_parameter,:pesquisa_geral.docid);
add_parameter(pl_id,'pesquisa',text_parameter,'P');
call_form('c:\ANACOM\RES\Forms\saida_oficio.fmx',no_hide,do_replace,query_only,pl_id);
end;

When the form B opens, i execute query with the parameter "docid" and the query runs.

If i close the form B and open it again, the query don't work...It works also at first time open.

I think there is a problem with call_form parameters...

It is ?

Best regards,

GP.

[Updated on: Sun, 30 November 2008 11:34]

Report message to a moderator

Re: Call_Form [message #362114 is a reply to message #362079] Mon, 01 December 2008 00:40 Go to previous message
rahshar
Messages: 26
Registered: July 2006
Location: Oman
Junior Member
The code is OK.

When ever you create a parameter list the buffer hold this list,
you need to destroy the list

check out this simple code every time a parameter list iss created a new id to the parameter list is initialized


declare
tag varchar2 := to_char(sysdate,'DDMMYYYYMISS');
begin
pl_id := get_parameter_list (tag) ;
IF NOT Id_Null (pl_id) THEN
Destroy_Parameter_List (pl_id) ;
END IF ;
pl_id := Create_Parameter_List (tag) ;
--
--
--
your code here
end;
Previous Topic: D2K issue
Next Topic: count length of a field
Goto Forum:
  


Current Time: Wed Dec 07 22:10:45 CST 2016

Total time taken to generate the page: 0.11770 seconds