Speaking from oracle experience I believe that it only return the
number of row deleted from the primary table and not the dependent
tables.
Nathan
On Aug 24, 2005, at 9:47 AM, [EMAIL PROTECTED] wrote:
Hi there!
Have you tried with FK and cascade delete ?
Which means one delete statement, but "behind" the scene, deletes
in several tables,
the number of deleted rows should then be correct ?
Erlend
-------
[Looks like my first post got lost when the list went down :-/]
Hi,
I'm a newbie to iBatis and as part of some unit-testing I need to
confirm
that the correct number of rows are deleted when removing some
records.
If do
<delete id="deleteXY">
delete from X where id=#value#;
delete from Y where id=#value#;
</delete>
I get the number of rows deleted from Y only.
If I split the delete into two separate entries:
<delete id="deleteX">
delete from X where id=#value#;
</delete>
<delete id="deleteY">
delete from Y where id=#value#;
</delete>
and call them both, I get the expected number of rows deleted when
I add them.
Is there a way to have only one call to <delete/> and get the total
number of rows deleted ?
TIA.
--
Graeme -