How to initate a trigger from a button.
622257Mar 6 2008 — edited Mar 7 2008Hi. I plan to create a trigger that creates or replaces a table with a bunch of new data from several sources.
I'd like to be able to offer the user a button to click and it will rebuild the table from this trigger.
My searches have turned up fruitless ...
Any suggestions where I can look or any advice on syntax ?
Do I need to have some kind of statement in an application process ?
Originally, I tried to place my original SQL stmt into an application process (instead of a trigger) but I need to use dynamic SQL from what I understand (through a similar posting) and that syntax is way beyond my abilities of undestnading at this point... I was hoping to just cut and paste my working SQL stmt from SQL Developer into Apex and let it run :) ... No such luck ....