> From: Claudio Valderrama C.

....

> Unfortunately, as Jason knows well, if I insert into V, IB (not FB) says in
> this case that you inserted three records. If you delete from V, IB will say
> that you deleted three records and on update, you will appear as updating
> three records. Now, do the same on W as above and you might get higher
> values. The reason is that IB has flawed logic, counting every loop over ...

First I thought I do understand this, but now if I tried it I realized I do not.

I created Table, Updatable-view, Non-updatable-view-made-updatable-by-triggers.
If I insert one row into any of these objects (by INSERT INTO t VALUES(...)),
I get "one row inserted" answer (isc_info_sql_records, isc_info_req_insert_count, ... etc.).
If I insert 5 rows (by INSERT INTO t SELECT * FROM t2),
I get "five rows inserted, five rows selected" answer.
I tried it with IB5.1 and IB6.0.0.627.

So, under which circumstances do I get "three records inserted" ?

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