Martijn Tonies wrote:

>>>>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
>
>

Thx Martijn, it works perfectly.
Adomas