Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with Transactions
Message
De
16/09/2004 03:48:28
Stuart Ramsey
Medical Business Systems
East Gosford, Australie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Problems with Transactions
Divers
Thread ID:
00942781
Message ID:
00942781
Vues:
85
In a compiled exe, out in the real world, being used by real users. This error randomly appears!

------------------------------------------------------------------
Visual FoxPro Reference

END TRANSACTION command cannot be issued without a corresponding BEGIN TRANSACTION command (Error 1591)
Contain transaction code between matched BEGIN TRANSACTION and END TRANSACTION pairs.

-----------------------------------------------------------------------------
The offending code from my program is below:

SELECT INVOICE
BEGIN TRANSACTION
DO CASE
CASE lnanswer = 6
REPLACE INVOICE.status WITH "P"
REPLACE INVOICE.oktoprn WITH .F.
CASE lnanswer = 7
REPLACE INVOICE.status WITH "?"
REPLACE INVOICE.oktoprn WITH .F.
ENDCASE
Thisform.pageframe1.page3.stat1.refresh
lmsuccess = TABLEUPDATE(0,.F.,'INVOICE')
IF lmsuccess
END TRANSACTION
ELSE
=MESSAGEBOX("Invoice Status failed to update successfully",16,"Transaction Error")
ROLLBACK
ENDIF

----------------------------------------------------------------------

Any suggestions would be gratefully appreciated.
Thanks
S Ramsey
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform