Re: Triggers on Views fire for table?

Luch wrote:
>
> Anybody have ideas how to get around or a good way to deal with this. I was
> given only select access to a certain view, I don't even know what table
> it's coming from. I want to process each record as it comes into the view
> (just like an insert trigger on a table).
>
> --
> Luch
> replace nospam with usa for e-mail.
>

Each record only "comes into the view" when you access the view.

Are you then modifying the records or just doing something like updating an on-screen display? You may have to set up a periodic process to monitor the view and process new records as you see them.

If you are going to modify these records then actually the correct solution is to get the trigger set on the real table (or tables). If you code the trigger properly, you should be able to lobby the DBA to install it. If it is really necessary for your project, then your manager should be able to support your request.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com