OraFAQ Forum: Forms » Re : too Slow

Home » Developer & Programmer » Forms » Re : too Slow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re : too Slow [message #86925]

Sun, 21 November 2004 19:12

jhsharma
Messages: 58
Registered: June 2004

Member

Hi Gurus

When i pass the parameter from one from to other form the execution becomes very slow why ? How to make it faster ?

�

regards

jhs

�

�

Report message to a moderator

Re: Re : too Slow [message #86926 is a reply to message #86925]

Sun, 21 November 2004 19:37

Frank
Messages: 7901
Registered: March 2000

Senior Member

Sounds to me like it's got nothing to do with the parameter.
Maybe your pre-form or wnfi trigger changed using this parameter ?
Maybe you introduced a new query that does not perform well ?
The parameter by itself could hardly make things go slower.

hth

Report message to a moderator

Re: Re : too Slow [message #86930 is a reply to message #86926]

Sun, 21 November 2004 20:44

jhsharma
Messages: 58
Registered: June 2004

Member

Hi guru's

can I have more than one block in the called form using the parameters/

regards

jhs

Report message to a moderator

Re: Re : too Slow [message #86945 is a reply to message #86930]

Mon, 22 November 2004 18:59

gaurav dantre
Messages: 24
Registered: June 2004

Junior Member

yes,
you can use the Add_parameter.
apply the following code and create the block_to_execute parameter in the form .
apply this code
DECLARE

list_id ParamList;

BEGIN

list_id := Create_Parameter_List('input_params');

Add_Parameter(list_id, 'block_to_execute',TEXT_PARAMETER,'BLock_name');

call_form('form_name.fmx',HIDE,DO_REPLACE,NO_QUERY_ONLY,list_id;

Destroy_Parameter_List(list_id);

END;

Report message to a moderator

Previous Topic:	validate item
Next Topic:	time calculation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 13:52:57 CDT 2024