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:
00612573
Views:
20
>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
> ENDIF
> IF llPreError .OR. llDataError .OR. llPostError
        * ? Do we need a Tablerevert() ?
>       ROLLBACK
> Else && Everything is fine 
>     END TRANSACTION
ENDIF
>
>But, I get 'must have a begin transaction before issuing endtransaction error. So, it must be me, again....
>
>TIA
>
>Ric
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform