General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Some basic transactions
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only