Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction Question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Transaction Question
Divers
Thread ID:
00830457
Message ID:
00830457
Vues:
41
(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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform