OraFAQ Forum: Forms » how can I execute 'when button pressed' trigger at run time

Home » Developer & Programmer » Forms » how can I execute 'when button pressed' trigger at run time

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

how can I execute 'when button pressed' trigger at run time [message #159417]

Sat, 18 February 2006 23:30

sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia

Junior Member

I have created push buttons with when button pressed triggers,
and now i want to execute the trigger of a button programetically at run time without clicking on the button, How can I do that ?

Report message to a moderator

Re: how can I execute 'when button pressed' trigger at run time [message #159424 is a reply to message #159417]

Sun, 19 February 2006 03:11

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Didn't Forms Help tackle this one for you? You are saying you want to EXECUTE a TRIGGER, have you tried EXECUTE_TRIGGER(trigger_name)?

MHE

Report message to a moderator

Re: how can I execute 'when button pressed' trigger at run time [message #159451 is a reply to message #159424]

Sun, 19 February 2006 15:12

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

Senior Member
Account Moderator

Perhaps yet another solution ... you could put the code (which now makes the WHEN-BUTTON-PRESSED trigger) into the procedure and call it a) from the trigger, b) programatically when needed.

Report message to a moderator

Re: how can I execute 'when button pressed' trigger at run time [message #159518 is a reply to message #159451]

Mon, 20 February 2006 02:27

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Even better, Littlefoot! I always try to have as little code as possible in the trigger body.

MHE

[Updated on: Mon, 20 February 2006 02:27]

Report message to a moderator

Re: how can I execute 'when button pressed' trigger at run time [message #160249 is a reply to message #159518]

Fri, 24 February 2006 01:45

samidc
Messages: 35
Registered: February 2006

Member

Use EXECUTE_TRIGGER('trigger name');
Mind one thing that if some how error comes up in trigger still the next statements after execute_trigger will get fired .
So after execute_trigger trap error using form_success built in

Thanks
SaMir.

Report message to a moderator

Previous Topic:	How can I assign a value from pl/sql library
Next Topic:	master-detail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:43:29 CDT 2024