Subject Re: [firebird-support] Re: Foreign Key implementation
Author Aage Johansen
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.