Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with Transactions
Message
From
16/09/2004 05:15:25
 
 
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:
00942799
Views:
20
SELECT INVOICE
BEGIN TRANSACTION
DEBUGOUT TXNLEVEL()
DO CASE
   CASE lnanswer = 6
     REPLACE status WITH "P"
         ,  oktoprn WITH .F.
    CASE lnanswer = 7
      REPLACE INVOICE.status WITH "?"
      REPLACE INVOICE.oktoprn WITH .F.
ENDCASE
* NEXT LINE position IS STRANGE
Thisform.pageframe1.page3.stat1.refresh
DEBUGOUT  TXNLEVEL( )
* you mix buffer with transaction !
IF TABLEUPDATE(0,.F.,'INVOICE')
   DEBUGOUT  TXNLEVEL( )
   END TRANSACTION
ELSE
   ROLLBACK
  =MESSAGEBOX("Invoice Status failed to update successfully",16,"Transaction Error")
ENDIF
* expected position is here
* Thisform.pageframe1.page3.stat1.refresh
Previous
Reply
Map
View

Click here to load this message in the networking platform