bug? db adapter master detail polling fails
Hi!
I encounter the following situation:
- I use a database adapter to poll for new data, using logical deletes on the table with a status field.
- I use a master-detail query
- I use a whereclause with a criteria on the detail table: for example I poll on emp but only for dept.DNAME='ACCOUNTING'.
When I use a reserved value (next to read, unread values) which is NOT NULL, the reserving goes wrong: I see that toplink tries to update the EMP table with a whereclause like this:
update emp
set status = 0
where status = 1
and dname='ACCOUNTING'
when I remove the reserved value it all works as it should.
Is this a bug?
Jeroen van Veldhuizen
Itude Technology