The TransactionCommit commits a transaction within the database.


Namespace: rocketsoftware.MVSP
Assembly: RocketMVSP (in RocketMVSP.dll)

Syntax

Visual Basic (Declaration)
Public Function TransactionCommit() As Boolean
C#
public bool TransactionCommit()
C++
public:
 bool TransactionCommit() sealed 
J#
public bool TransactionCommit()
JScript
public  function TransactionCommit() : bool

Return Value

True is returned if the commit 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()
 

See Also