ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Tools / WDTrans
  • Overview
  • How to?
  • Freeing records held by a transaction
  • Freeing the records held by a transaction 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: Freeing the records held by a transaction
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Overview
Sets to a normal state all records that are wrongly marked as held by a transaction. If a record in the specified data file is considered to be in a transaction, but does not belong to any current transaction, it is automatically freed.
Note: This is an advanced feature. This feature should be used when it is not possible to roll back failed transactions (e.g. when transaction files have been deleted).
How to?

Freeing records held by a transaction

To free the records held by a transaction:
  1. Open WDTrans.
  2. Select "Free all records held by a transaction".
  3. Select the directory containing the data files in the current transaction. The list of data files in the directory is displayed.
    Note: No file held by the transaction must be in this directory.
    If data files are located in subdirectories, check "When adding a directory, include files from all subdirectories".
  4. If some data files are password protected, specify the password. This password is required to free the records held by the transaction.
  5. Click the "Free all records held by a transaction" button. The records are freed.

Freeing the records held by a transaction command line mode

To free the records held by a transaction via a command line:
WDTrans /Fic = <Directory>
/Mdp = <Password>
/Option = <Type of action performed>
/Log = <Log file>
/ExploresousRep = <Yes/No>
The table below presents the different elements that can be found on the command line:
ParameterMeaning
/Fic = <Directory>Directory containing the files where the records must be freed
/Mdp = <Password>File password. The same password is used for all files.
/Option = <Type of action to perform>Option of WDTrans to run. To free the records held by a transaction, this option should be set to 7.
/Log = <Log File>Full path of the log file (.log) to create.
/ExploresousRep = <Yes/No>"Yes" to explore subdirectories of the directory specified in the "/Fic" parameter ("No" by default).
Note: To use a different password for each file, it is recommended to use the WLanguage transaction management functions directly.
Example: Free all records held by a transaction located in the "WD Transaction" directory:
WDTRANS.EXE /Fic="C:\Temp\WD Transaction" /option=7
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/24/2025

Send a report | Local help