|
|
|
|
|
- Error cases
- Handling records during a transaction
- Transactions and independent HFSQL context
- OLE DB and Native Connectors
<Connection variable>.TransactionEnd (Function) In french: <Variable Connexion>.TransactionFin
Not available with this kind of connection
Validates the current transaction: MaConnexion1 is Connection
MaConnexion1.TransactionStart()
WHEN EXCEPTION IN
Commande.Ajoute()
MaConnexion1.TransactionEnd()
DO
MaConnexion1.TransactionCancel()
END
Syntax
Validating a transaction in progress on a connection Hide the details
<Result> = <Connection>.TransactionEnd()
<Result>: Boolean - True if the transaction is ended,
- False if a problem occurs. HErrorInfo returns more details about the error.
Caution: If a global transaction is started, the function does nothing.. The syntax 2 must be used.
<Connection>: Connection variable Name of the Connection variable that describes the connection to use.
Validating a global transaction in progress Hide the details
<Result> = TransactionEnd()
<Result>: Boolean - True if the transaction is ended,
- False if a problem occurs. HErrorInfo returns more details about the error.
Remarks Error cases - Transaction nesting: it is not possible to nest transactions (i.e. to call function <Connection variable>.TransactionStart or function <Connection variable>.Transaction within a transaction).. In this case, error 70031 occurs.
- A fatal error is displayed in the following cases:
- A transaction is started on all the connections while there is at least one connection in transaction.
- A transaction is started on a connection while a transaction was already started on all the connections.
- A transaction is started on all the connections while there is at least one connection whose isolation level is not "Read Uncommitted".
Handling records during a transaction Transactions and independent HFSQL context
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|