Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction Question
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Transaction Question
Miscellaneous
Thread ID:
00830457
Message ID:
00830457
Views:
39
(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.
Jon Craig, MCP
Software Engineer
Parity Corporation
jcraig@paritycorp.com
Next
Reply
Map
View

Click here to load this message in the networking platform