ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Tools / WDTrans
  • Overview
  • How to?
  • Rolling back all changes made to the files held by a transaction
  • It is also possible to roll back the changes made to a file held by a transaction in command line mode:
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
WDTrans: Rolling back all changes made to the files held by a transaction
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Overview
WDtrans works as follows:
  • If no transaction is in progress, restores the integrity of the database and rolls back the transactions that have not been successfully completed (if a power outage occurs, for example).
  • If a transaction is in progress, rolls back all changes made to the files since the beginning of the transaction. In this case, the transaction is canceled without interrupting the program execution.
How to?

Rolling back all changes made to the files held by a transaction

To roll back the changes made to a file held by a transaction:
  1. Open WDTrans.
  2. Select "Roll back a transaction".
  3. Select the desired file in the file picker.
    The list of data files (with their full path) in the transaction is displayed. For each file, the ID of the computer that performs an operation in a transaction is displayed.
  4. If some data files are password protected, specify the password. This password is required to roll back the transaction.
  5. Disable (if necessary) the management of duplicates and/or integrity.
  6. Click the "Roll back transaction" button. The transaction is rolled back.

It is also possible to roll back the changes made to a file held by a transaction in command line mode:

WDTrans /Fic = <File>
/Mdp = <Password>
/Option = <Type of action performed>
/Log = <Log file>
The table below presents the different elements that can be found on the command line:
ParameterMeaning
/Fic = <File>Full path of the transaction file (.TRS file)
/Mdp = <Password>Password associated with the file to process (single file)
/Option = <Type of action to perform>Option of WDTrans to run. To roll back the changes made to a file held by a transaction, this option should be set to 6.
/Log = <Log File>Full path of the log file (.LOG) to create.


Example: Roll back transactions saved in the "WD Transactions.TRS" file:
WDTRANS.EXE /Fic="C:\Temp\WD Transaction.TRS" /option=6
Minimum version required
  • Version 9
Comments
Click [Add] to post a comment

Last update: 02/02/2025

Send a report | Local help