(This is happening in Mere Mortals framework, but is a general issue)
Has anyone seen this issue?
I have parent and child bizobjs(views) with associated grids on form. The following is very simplified. When I save, a transaction is started. After all changes are done, END TRANSACTION is fired. Problem is, sometimes an AFTERROWCOLCHANGE() event on the childs grid is fired in middle of the transaction! The AfterRowColChange() calls another method that does a few REQUERY() calls, which results in an error "1593: Command Cannot Be Issued Within a Transaction."
Funny thing is, if I break before the END TRANSACTION and step through, the AfterRowColChange() does not fire. If I break after, the error occurs and I can see I'm in middle of the END TRANSACTION.
I can move the Requery code or wrap it in a check on TXNLEVEL(), but I was wondering if there was something I missed?
Thanks,
Jon Craig
Parity Corp.