Subject | Re: Firebird v1.0 Final and the result set with a newly created column?!?!? (second try) |
---|---|
Author | alex_vnru |
Post date | 2002-05-23T08:28:37Z |
--- In ib-support@y..., "Thomas Steinmaurer" <ts@i...> wrote:
IBExpert and RECREATE and CREATE statements.
I have another amazing info which can be of interest for you. During
a discussion about triggers on system tables I created BI triggers on
RDB$RELATIONS, RDB$RELATION_FIELDS and RDB$FIELDS, disconnected from
database and connected once more using WISQL. As expected, this
triggers did'nt work. But when I connected using IBExpert, trigger on
RDB$RELATIONS did'nt work but both another worked!!! I was said
trigger on RDB$PROCEDURE_PARAMETERS work too and this triggers survive
backup/restore but I have'nt time now to investigate it. Amazing is
too that Alexander Khvastunov said he did'nt made any special efforts
in this direction and could'nt explain why this triggers works when
IBExpert is connected and don't work in WISQL session.
Best regards, Alexander V.Nevsky.
> Hi all,Hi, Thomas. I reproduced it on LI-V6.2.796 using both WISQL and
> giving this a second (last) try.
IBExpert and RECREATE and CREATE statements.
I have another amazing info which can be of interest for you. During
a discussion about triggers on system tables I created BI triggers on
RDB$RELATIONS, RDB$RELATION_FIELDS and RDB$FIELDS, disconnected from
database and connected once more using WISQL. As expected, this
triggers did'nt work. But when I connected using IBExpert, trigger on
RDB$RELATIONS did'nt work but both another worked!!! I was said
trigger on RDB$PROCEDURE_PARAMETERS work too and this triggers survive
backup/restore but I have'nt time now to investigate it. Amazing is
too that Alexander Khvastunov said he did'nt made any special efforts
in this direction and could'nt explain why this triggers works when
IBExpert is connected and don't work in WISQL session.
Best regards, Alexander V.Nevsky.