Re: trigger newbie: odd "fail" behavior?

[7 reeds]

oops, I said in the initial post that I have not seen the odd behavior of 5 grouped inserts producing 6 resulting records. That was not true. I mis-stated that section. To recap:

I had 5 inserts grouped together and executed as a block. I expected table testA to have the 5 original vales. I expected testB to have 4 of the original values minus the "fail". I also expected to see a message about the missing SP.

Instead, the result was SIX records in testA: 'a', 'b', 'fail', 'fail', 'fail', 'fail'. testB had just two records: 'a', 'b'.

I have reproduced this with a grouped insert.