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

Click here to load this message in the networking platform