Syntax

Visual Basic (Declaration)
Public Function TransactionRollback() As Boolean

C#
public bool TransactionRollback()

C++
public: bool TransactionRollback() sealed

J#
public bool TransactionRollback()

JScript
public function TransactionRollback() : bool

Return Value

True is returned if the rollback was sucessful, otherwise false is returned and an exception is thrown.

Remarks

Only supported on D3 Example connects and processes a file update as a transaction and gives the option of either commiting or rolling back the transaction.

	Copy Code
Dim returncode as boolean Dim mvsp as new rocketsoftware.MVSP.Pick Dim mvspfunctions as new rocketsoftware.MVSP.Functions Dim params as string = "" Dim itemid as string = "" Dim attbody as string = "" Dim itembody as string = "" Dim am as string = chr(254) returncode = mvsp.Connect("localhost",9000,"dm","") If returncode = True then returncode = mvsp.Logto("MVDEMO","") If returncode = True then itemid = "1" ' Itemid returncode = mvsp.TransactionBegin itembody = mvsp.FileReadu("CUSTOMERS",itemid) attbody = "New York" itembody = mvspfunctions.Replace(itembody,3,attbody) returncode = mvsp.FileWriteu("CUSTOMERS", itemid, itembody) If MsgBox("Commit Transaction ? " , MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then mvsp.TransactionCommit() Else mvsp.TransactionRollback() End If End if End if returncode = mvsp.CloseConnection()

Copy Code

 Dim returncode as boolean
 Dim mvsp as new rocketsoftware.MVSP.Pick
 Dim mvspfunctions as new rocketsoftware.MVSP.Functions
 Dim params as string = ""
 Dim itemid as string = ""
 Dim attbody as string = ""
 Dim itembody as string = ""
 Dim am as string = chr(254)
 returncode = mvsp.Connect("localhost",9000,"dm","")
 If returncode = True then
    returncode = mvsp.Logto("MVDEMO","")
    If returncode = True then
          itemid = "1" ' Itemid
          returncode = mvsp.TransactionBegin
          itembody = mvsp.FileReadu("CUSTOMERS",itemid) 
          attbody = "New York"
          itembody = mvspfunctions.Replace(itembody,3,attbody)
          returncode = mvsp.FileWriteu("CUSTOMERS", itemid, itembody) 
          If MsgBox("Commit Transaction ? " , MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then
             mvsp.TransactionCommit()
          Else
             mvsp.TransactionRollback()
        End If    
    End if
 End if
 returncode = mvsp.CloseConnection()

Syntax

Return Value

Remarks

See Also