Featured Products
Omegabundle for Xojo 2025 Products

Transactions Manager

Use transactions to ensure operations succeed and preserve data consistency and integrity.

New in 2025.

Visual Transactions Manager

Valentina Studio Data Editor includes management options for data sources that support transactions. These include:

  • DuckDB Local
  • SQLite Local

 

  • MySQL
  • MSSQL
  • PostgreSQL
  • DuckDB Server (Valentina Server)
  • SQLite Server (Valentina Server)
     

 

Visual Transactions EditorTransactions ensure that either all the operations succeed or none are applied to the database, preserving data consistency and integrity. By default, each change to the database is committed automatically. The Data Editor allows you to start a new, separate transaction. You can then make changes to one or more tables and either commit or roll back those changes as a single unit.

The new options for working with transactions are located at the top of the Data Editor tab:

  • Transactions (Tx) button is used to initiate and stop transaction mode and to modify transaction settings
  • Commit button is used to commit changes made after starting a transaction
  • Rollback button is used to rollback changes made after starting a transaction

A long press on the Transactions button opens a menu that provides access to the Transactions Settings Menu.

Transactions Settings MenuConfigure options such as Auto-Restart Transaction and, for supported databases, the Isolation Level. These settings enable you to customize transaction behavior to suit your needs.