> >>Is there anything like INSTEAD OF TRIGGERS in FB ?
> >>I create complicated view, then I write INSTEAD OF
> >>(insert/delete/update ) trigger, and view becomes writable
> >>
> >>
> >
> >Write normal triggers and you should be able to do that
> >just fine.
> >
> >
> >
> >
>
>
> Yeah, with normal select view it will be fine, but what if I have
> view : "select count(*) from A1".
> This view obviously is not writable, but if I had trigger "INSTEAD OF
> INSERT", I could write to it.
> then I could write to any view, with having apropriate triggers.

When you create "normal" triggers on a non-writable view with Firebird,
you ARE creating "instead of" triggers. But Firebird doesn't know the
"instead of" keywords.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com