| Call_Form [message #362079] |
Sun, 30 November 2008 11:33  |
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
