Re: Triggers on Views fire for table?

Basically I wanted to take the data being inserted into the view (whatever is in the :new variables) and process it, then insert/move it to other tables. If I understand correctly that the record only comes into the view when the view is queried, I suppose the type of trigger I wanted to create isn't possible.

The DBA will only give me access to the view, so I'll probably have to go with a timed process that periodically queries the view like you mention.

thank you both for your help

--
Luch
replace nospam with usa for e-mail.


"Ed Prochak" <edprochak_at_magicinterface.com> wrote in message
news:3C0E4824.6DB06D50_at_magicinterface.com...


>

>

>

> 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

>