Peter Brawley Wrote:
-------------------------------------------------------
> >> You saw that where?
>
> >"The trigger cannot use statements that
> explicitly or implicitly begin or
> > end a transaction such as START TRANSACTION,
> COMMIT, or ROLLBACK."
>
> >
>
http://dev.mysql.com/doc/refman/5.0/en/trigger-syn
> tax.html
>
> Read that sentence again again. It is about
> triggers and functions, not stored procedures.
But I am calling a stored procedure from a trigger. That would seem to be at least "indirect" but I am here asking for help, not debating what I get. Thanks.
> But why not implement this simple logic within the
> Trigger?
Mainly because I had not considered it until I read your question :)
Thanks again, I'll try that in the morning.