Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some basic transactions
Message
From
29/01/2002 20:31:44
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00612539
Message ID:
00612563
Views:
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
>> 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... :-)

Sorry, that is just a typo.... have corrected my example.
Previous
Reply
Map
View

Click here to load this message in the networking platform