Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with Transactions
Message
From
16/09/2004 04:46:53
 
 
To
16/09/2004 03:48:28
Stuart Ramsey
Medical Business Systems
East Gosford, Australia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00942781
Message ID:
00942792
Views:
19
I think END TRANSACTION cannot be in IF...ENDIF block.
Try this:
SELECT INVOICE
BEGIN TRANSACTION
DO CASE
   CASE lnanswer = 6
        REPLACE status  WITH "P",;
                oktoprn WITH .F.
   CASE lnanswer = 7
        REPLACE status  WITH "?",;
                oktoprn WITH .F.
ENDCASE
Thisform.pageframe1.page3.stat1.refresh
IF .NOT. TABLEUPDATE(0,.F.,'INVOICE')
   =MESSAGEBOX("Invoice Status failed to update successfully",16,"Transaction Error")
   ROLLBACK
ENDIF
END TRANSACTION
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform