Re: Passing parameters to table trigger

[Quoted] In article <92va25$7k5$1_at_wanadoo.fr>,   "Jérôme PERRET" <jperret_at_freesurf.fr> wrote:
> Can I pass a value (like with a parameter to a procedure) from Forms
 to a
> trigger based on a table ?
>
> Jérôme
>
>

[Quoted] Simple answer, no.

A table based trigger is activated any time a particular action is applied to the table. It has access to the data available in the action ( inserted columns, updated columns, etc) and any information commited to the database. You would be hard pressed to allow for more than one user of Forms to get a specific action using a trigger.

If you need to perform some activity to a table from within Forms, you might consider writing a stored procedure to do the work. You have the available parameters, and you can control what is happening.

However, you may have to override a lot of the internal processing of Forms. I would like to know what exactly you are trying to do. For [Quoted] instance, is a pre-insert trigger in your Form more appropriate? Is the action actually just a simple table trigger. Remember almost anything you are thinking about doing has already been done by someone else. Many of the improvements in Forms over the years are do to the needs of the developers.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/