OraFAQ Forum: Forms » navigation triggers in WHEN-WINDOW-ACTIVATED

Home » Developer & Programmer » Forms » navigation triggers in WHEN-WINDOW-ACTIVATED (forms 6i)

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

navigation triggers in WHEN-WINDOW-ACTIVATED [message #500525]

Tue, 22 March 2011 00:45

firefoze
Messages: 1
Registered: March 2011
Location: Sri Lanka

Junior Member

Hi,

A requisition application shows the latest requisition details in the homepage and allow the users to go particular requisitions (extract) details from a button (CALL_FORM), also they can modify the records in that form.

I want to give an EXECUTE_QUERY (WHEN-WINDOW-ACTIVATED) when im returning to the home page and the cursor should return to the last row where i was.

Please guide me to do this from navigation triggers (with out writing a select statement in when-window-activated).

Thanks in Advance

Attachment: reqs.JPG
(Size: 41.68KB, Downloaded 647 times)

Report message to a moderator

Re: navigation triggers in WHEN-WINDOW-ACTIVATED [message #500556 is a reply to message #500525]

Tue, 22 March 2011 04:14

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

Senior Member
Account Moderator

Try something like this: in a button (that calls another form), store current record number into a global variable:

-- WHEN-BUTTON-PRESSED trigger

:global.where_was_i := :system.trigger_record;

call_form('another_form');

When you're back:

execute_query;

go_record(:global.where_was_i);

Report message to a moderator

Previous Topic:	Hide username and password
Next Topic:	Error in Calender Binding and Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:02:16 CDT 2024