Adam wrote:

> ...
>
> Then you must find this not sensible:
>
> Tr1:
> insert into employee_project (emp_no, proj_id) values (4, 'GUIDE');
> [don't commit]
>
> Tr2:
> update employee set salary = salary+100 where emp_no=4;
>
> Firebird is perfectly happy to do it in this order, but surely the
> same logic should disallow this?
>

I would think that the update works fine, but it isn't updating any
record (Rowsaffected=0) since it cannot see the record with EMP_NO=4.

--
Aage J.