manually decomposed m:n associations

[Ferran Parra <fe...@mubimedia.com>]

Hello to all,

I have a manually decomposed association m:n, like the "person, role,
project" example in the "Advanced O/R" tutorial. In the table which
corresponds to the object "role" new rows are inserted and the rows are
updated correctly, but if, for example, before updating I had 5 rows
associated, and afterwards only 3, it never deletes the 2 rows left over,
which are no longer associated! In fact, if I do an update that
un-associates ALL 5 rows, it doesn't delete either! Whereas there should be
0 rows associated after the update, there are still 5 !?!

What could I be doing wrong? What could be the reason for this (seemingly)
strange behavior?

Thanks in advance,
ferranito


-------------------------------------------------------
Ferran Parra
ferran_p@mubimedia.com
http://www.mubimedia.com
MUBIMEDIA S.L.
C/ Mallorca, 275, 1r 2a 08008 BCN
Tel: 93 215 21 91 / Fax: 93 215 41 21
-------------------------------------------------------