Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with Transactions
Message
De
16/09/2004 05:15:25
 
 
À
16/09/2004 03:48:28
Stuart Ramsey
Medical Business Systems
East Gosford, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00942781
Message ID:
00942799
Vues:
21
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform