Subject Re: [ib-support] Firebird RC1
Author Claudio Valderrama C.
""Ivan Prenosil"" <prenosil@...> wrote in message
> So, under which circumstances do I get "three records inserted" ?

Insert in a naturally updatable view (this is important) with IB6.01 and you
will understand. If you want fun, write a before and after triggers that do
nothing useful. Or you can use an older FB:

SQL> set count;
SQL> insert into w values(0);
Records affected: 3

SQL> show view w;
C INTEGER Nullable
View Source:
==== ======
select b from v

Triggers on Table W:
WT, Sequence: 0, Type: BEFORE INSERT, Active

SQL> show view v;
B INTEGER Nullable
View Source:
==== ======
select a from t

and T is a humble table with one field, no triggers. Neither V nor T have

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing