PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Special cases
  • Handling records during a transaction
  • Transactions and independent HFSQL context
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
Transforms all the records "in transaction" into "normal" records if these records do not belong to a transaction currently in progress. If a record found in the specified data file is considered as being in transaction but does not belong to a transaction in progress, it is automatically freed.
Caution: this function is an advanced function. This feature must be used when it is not possible to cancel the transactions that have failed (deleted transaction files for example).
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVWEBDEV - Server code This function is now available to free the transactions on the data files of a HFSQL cluster.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVWEBDEV - Server code This function is now available to free the transactions on the data files of a HFSQL cluster.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVWEBDEV - Server code This function is now available to free the transactions on the data files of a HFSQL cluster.
Example
// Frees all the records in transaction that may be used
HTransactionFree(Customer)
Syntax

Freeing a data file Hide the details

<Result> = HTransactionFree([<File Name>])
<Result>: Boolean
  • True if the operation is performed,
  • False if a problem occurred. HErrorInfo returns more details about the error.
<File Name>: Optional character string (with quotes)
Name of the HFSQL Classic or Client/Server data file for which the records in transaction must be freed.
If this parameter is not specified, HTransactionFree handles the last data file used.
AndroidAndroid Widget iPhone/iPadWindows Mobile Only the HFSQL Client/Server data files can be used.

Freeing a record found in a data file Hide the details

<Result> = HTransactionFree([<File Name>,] <Record Number>)
<Result>: Boolean
  • True if the operation is performed,
  • False if a problem occurred. HErrorInfo returns more details about the error.
<File Name>: Optional character string (with quotes)
Name of the HFSQL Classic or HyperFileSQL Client/Server data file for which the record in transaction must be freed.
If this parameter is not specified, HTransactionFree handles the last data file used.
AndroidAndroid Widget iPhone/iPadWindows Mobile Only the HFSQL Client/Server data files can be used.
<Record Number>: Integer
Number of the record to free.
If this parameter is equal to 0 or to the hCurrentRecNum constant, HTransactionFree handles the current record.
Remarks

Special cases

  • This function can only be used for the data files in HFSQL format. For all the other types of data files, this function has no effect and it returns True.
  • The records that cannot be read (locked records for example) are ignored.
  • Windows Mobile This function can be used with HFSQL Client/Server data files only.
  • AndroidAndroid Widget iPhone/iPad The management of transactions is available for the HFSQL Client/Server databases.
  • Versions 21 and later
    This function can be used to free the transactions performed on data files found in a HFSQL cluster.
    New in version 21
    This function can be used to free the transactions performed on data files found in a HFSQL cluster.
    This function can be used to free the transactions performed on data files found in a HFSQL cluster.

Handling records during a transaction

During a transaction, some rules must be complied with when handling the records. See Transactions: Handling records during a transaction for more details.

Transactions and independent HFSQL context

When copying a context, if a transaction is in progress on the first context, the new context is not in transaction. You must call HTransactionStart to start a transaction in the new context.When copying a context, if a transaction is in progress on the first context, the new context is not in transaction. You must call HTransactionStart (or HTransaction) to start a transaction in the new context.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment