Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some basic transactions
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00612539
Message ID:
00612543
Vues:
30
>I no there is a thread on this but I cannot find it.... a simple transaction statement:
>BEGIN TRANSACTION
> *Just in case we need to do something first (like get a new idnumber)
> llPreError = THISFORM.PreEntryFunction()
> IF !llPreError
>  llDataError = !TABLEUPDATE(.T.)
>   IF llDataError
>    *fix the immedate table problems _dataenvironment.initialselectedalias()
>    IF !llPreError .AND. !llDataError
>      *Maybe now we will send a message to someone
>      llPostError = THISFORM.PostEntryFunction()
>    ENDIF
> ENDIF
> IF llPreError .OR. llDataError .OR. llPostError
>  ROLLBACK
> ENDIF
>END TRANSACTION
>But, I get 'must have a begin transaction before issuing endtransaction error. So, it must be me, again....
>
>TIA
>
>Ric


For what I can see, you have missed a ENDIF somewhere... :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform