>
>
> sosingus wrote:
> > I've tried adding triggers to system table, it is possible.
>
> Since you use Firebird 1.5, please note that they would be gone after
> backup+restore
>
> Anyway, what you would have to do is create a trigger on RDB$RELATIONS
> (and RDB$RELATION_FIELDS if you need detailed info). This trigger could
> generate triggers for the table which is being created or modified using
> EXECUTE STATEMENT. I believe full support for this is only available in
> Firebird HEAD, so it will be there in Firebird 3.0 ?
>
>
> Even then, it is not trivial to implement. You are better off writing a
> simple application to do the job of generating triggers for you, or use
> a ready-made solution like ibLogManager.
>

Thank you for suggestions, but, what I would like to achieve is to log
changes within same transaction, I can do that by modifying application
code, but it requires too much of programming since application
architecture currently is not straight forward for likewise operations.
And, I would prefer to have it on the server side anyway.

- Sofija

>
>
> --
> Milan Babuskov
>