Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scripting_function


Panel
titleDescription

Closes the transaction with the given ID. You must commit or rollback the transaction before you close it. Closing the transaction will return its database connection to the pool. The transaction ID will no longer be valid.

Client permissions restrictions


Panel
titleSyntax

system.db.closeTransaction(tx)

  • Parameters

String tx - The transaction ID.

  • Returns

Nothing

  • Scope

Gateway, Vision Client, Perspective Session

Panel
titleCode Examples

There are no examples available for this function. 

Code Block
titleRunning a Query Using Query Transactions
# This example starts a transaction with a 5 second timeout against the project's default database, using the default isolation level. Then it executes a series of update calls, 
# and commits and closes the transaction.
  
txId = system.db.beginTransaction(timeout=5000)
status=2
  
for machineId in range(8):
   system.db.runPrepUpdate("UPDATE MachineStatus SET status=? WHERE ID=?",
      args=[status, machineId], tx=txId)
  
system.db.commitTransaction(txId)
system.db.closeTransaction(txId)
Panel
titleKeywords

system db closeTransaction, db.closeTransaction