|
|
|
|
- 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:
MyConnection1 is Connection  // Start transaction on data files associated with MyConnection1 MyConnection1.TransactionStart()  // Code used to prepare the order to added // ...  WHEN EXCEPTION IN // Add the order Order.Add() // Validate the addition MyConnection1.TransactionEnd() DO // Delete the order lines MyConnection1.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: The function has no effect if a global transaction is started. 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 - Nesting transactions: Transactions cannot be nested (i.e. <Connection variable>.TransactionStart or <Connection variable>.Transaction cannot be called in 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 mode is not "Read Uncommitted".
Handling records during a transaction Transactions and independent HFSQL context
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|