Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some basic transactions
Message
From
29/01/2002 21:52:56
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00612539
Message ID:
00612577
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
>> ENDIF
>> IF llPreError .OR. llDataError .OR. llPostError
>        * ? Do we need a Tablerevert() ?

Why of course we do.... that is why I am the silly one!!! Thank you very much.

Ric


>>       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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform