PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Starting a transaction
  • Validating a transaction
  • Canceling a transaction
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
From version 21, you have the ability to manage the transactions in SQL code.
Starting a transaction
The following SQL syntaxes can be used to start a transaction:
  • BEGIN
  • BEGIN WORK
  • BEGIN TRANSACTION
  • START TRANSACTION
  • START TRANSACTION ISOLATION <Level>. The <Level> parameter can correspond to:
    • READ UNCOMMITTED
    • READ COMMITTED
    • REPEATABLE READ
    • SERIALIZABLE
    If no isolation level is defined in the SQL command, the isolation level that is currently defined will be used for the transaction.
To define the isolation level, you also have the ability to use the following syntax:
SET ISOLATION <Level>
The <Level> parameter can correspond to:
  • READ UNCOMMITTED
  • READ COMMITTED
  • REPEATABLE READ
  • SERIALIZABLE
Validating a transaction
The following SQL syntaxes can be used to validate a transaction:
  • COMMIT
  • COMMIT WORK
  • COMMIT TRANSACTION
The syntaxes used to chain a new transaction are also available:
  • COMMIT AND CHAIN
  • COMMIT WORK AND CHAIN
  • COMMIT TRANSACTION AND CHAIN
Canceling a transaction
The following SQL syntaxes can be used to cancel a transaction:
  • ROLLBACK
  • ROLLBACK WORK
  • ROLLBACK TRANSACTION
The syntaxes used to chain a new transaction are also available:
  • ROLLBACK AND CHAIN
  • ROLLBACK WORK AND CHAIN
  • ROLLBACK TRANSACTION AND CHAIN
See also
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment