Today I tried it again with the same database and got "Records affected: 3".
I do not know what I made wrong yesterday.

Ivan
http://www.volny.cz/iprenosil/interbase

> From: Claudio Valderrama C.
> > 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