""Ivan Prenosil"" <prenosil@...> wrote in message
news:20011127174009.3633315048@......

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

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing