Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some basic transactions
Message
 
To
29/01/2002 18:38:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00612539
Message ID:
00612543
Views:
29
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform