|
|
|
|
|
|
|
|
|
|
- Handling records during a transaction
- Transactions and independent HFSQL context
HTransactionInterrupted (Function) In french: HTransactionInterrompue
  Available only with these kinds of connection
Allows you to find out whether a transaction was interrupted (the transaction was neither validated nor canceled). The characteristics of the interrupted transaction are returned by the HFSQL variables. We advise you to call this function in the project initialization code. If the transaction is interrupted, you can: - start WDTRANS or WDOptimizer.
- start the HFSQL Control Center.
- cancel the transaction programmatically.
IF HTransactionInterrupted("") = True THEN
HTransactionCancel()
END
Syntax
<Result> = HTransactionInterrupted([<Transaction file>])
<Result>: Boolean - True if a transaction was interrupted,
- False if no transaction was interrupted. The following HFSQL variables are updated:
| | | H.TrsApplicationName | Value if transaction interrupted: Application name in the form: Executable name(Project name).
Value if transaction not interrupted: Empty string ("").
Note This variable is only available in HFSQL Client/Server mode. | | H.TrsInternalID | Value if the transaction has been interrupted: Internal number uniquely identifying the transaction.
Value if transaction not interrupted: -1 | | H.TrsMachineName | Value if the transaction was interrupted: Client workstation name and workstation IP address.
Value if transaction not interrupted: Empty string ("").
Note This variable is only available in HFSQL Client/Server mode. | | H.TrsPost | Value if the transaction was interrupted: Identifier defined by the HComputer function or name of the machine from which the transaction was initiated.
Value if transaction not interrupted: Empty string ("") |
<Transaction file>: Optional character string Full name of the transaction file (used to store the operations performed within the transaction). This file is automatically destroyed when HTransactionEnd or HTransactionCancel is used.
If this name corresponds to an empty string ("") or is not specified, the transaction file used is the default transaction file (in the application directory with the name: <Nom Projet>_$TRS_OPERATION.trs)..
Remarks Handling records during a transaction 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 (or HTransaction) to start a transaction in the new context. Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|