OraFAQ Forum: Forms » CALL

Home » Developer & Programmer » Forms » CALL_FORM

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

CALL_FORM [message #195058]

Tue, 26 September 2006 15:25

gutta_rajen@yahoo.com
Messages: 16
Registered: September 2006

Junior Member

HELLO 2 EVERY ONE

I STRUCK WITH A PROBLEM.mY REQUIREMENT IS SUCH THAT...
IF THE THE USER ENTER A ORDER_ID AND PRESS THE BUTTON..THEN ANOTHER FORM HAS TO BE CALLED AND DETAILS OFTHE RELATED ORDER_ID SHOULD BE DISPLAYED...
CAN ANY ONE HELP IN THIS MATTER

THANKS
RAJENDRA

Report message to a moderator

Re: CALL_FORM [message #195061 is a reply to message #195058]

Tue, 26 September 2006 15:33

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use a parameter or a global variable to transfer "order_id" to another form which can be called using CALL_FORM or OPEN_FORM. In there, create a default WHERE condition for the block and execute query in the KEY-STARTUP trigger.

Report message to a moderator

Re: CALL_FORM [message #195069 is a reply to message #195061]

Tue, 26 September 2006 17:49

gutta_rajen@yahoo.com
Messages: 16
Registered: September 2006

Junior Member

Hi,
i tried but a new form is opening but execute query is not working...can u plz send me the code.

Report message to a moderator

Re: CALL_FORM [message #195094 is a reply to message #195069]

Wed, 27 September 2006 01:19

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I don't have it. However, keywords like "parameter", "global variable", "execute query", "trigger" should help you do it yourself (or, at least, Google for it).

Report message to a moderator

Re: CALL_FORM [message #195228 is a reply to message #195069]

Wed, 27 September 2006 08:24

ChrisCash
Messages: 2
Registered: September 2006

Junior Member

gutta_rajen@yahoo.com wrote on Wed, 27 September 2006 00:49

Hi,
i tried but a new form is opening but execute query is not working...can u plz send me the code.

DECLARE
v_password VARCHAR2 (10);
v_role VARCHAR2 (1);
BEGIN
:GLOBAL.emp_number := :logged.emp_number;
:GLOBAL.user_emp_number := :logged.emp_number;

I have done something similar with a employee number. Here is athe first part of the code I used.

Hope this helps.

Report message to a moderator

Re: CALL_FORM [message #195287 is a reply to message #195228]

Wed, 27 September 2006 15:51

gutta_rajen@yahoo.com
Messages: 16
Registered: September 2006

Junior Member

Hi
thank u it's working...

Report message to a moderator

Previous Topic:	Please help me :"FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA01422&
Next Topic:	Little help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:40:19 CDT 2024