SQLTransaction (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Syntax 2: Performing a transaction on a connection
Nesting transactions
Native MySQL Connector

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLTransaction (Function)

In french: SQLTransaction

Allows you to start, validate or cancel a transaction:

on the files of a database opened by SQLConnect,
on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.

Remark: This function is the only SQL function that can be used with the HFSQL functions (to perform transactions on an external database handled by the HFSQL functions for example).

Versions 18 and later

This function is now available in Android Widget mode.

New in version 18

This function is now available in Android Widget mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 24 and later

This function is now available for iPhone/iPad applications.

New in version 24

This function is now available for iPhone/iPad applications.

Example

See additional examples

Syntax

Transaction on the files of a database opened by SQLConnect Hide the details

<Result> = SQLTransaction(<Indicator>)

<Result>: Boolean

True if the operation was performed,
False otherwise.

<Indicator>: Integer constant

Type of transaction operation to perform:
sqlStart Starts the transaction.
sqlCommit End the transaction.
sqlRollBack Cancels the transaction.
Remark: This syntax is not available in Android.

Transaction on the files of a database opened by a connection described in the analysis or by HOpenConnection Hide the details

<Result> = SQLTransaction(<Indicator> , <Connection>)

<Result>: Boolean

True if the operation was performed,
False otherwise.

<Indicator>: Integer constant

Type of transaction operation to perform:
sqlStart Starts the transaction.
sqlCommit End the transaction.
sqlRollBack Cancels the transaction.

<Connection>: Character string (with or without quotes)

Name of connection used to access the database. This name was defined in the data model editor or by HOpenConnection. This connection must have been described during the call to SQLTransaction. If the connection is not opened during the call to SQLTransaction, the specified connection is automatically opened.

Remarks

Syntax 2: Performing a transaction on a connection

To perform a transaction on a connection, you must:

Start the connection (SQLTransaction(sqlStart)).
Perform the operations on the data files with the relevant HFSQL functions.
End the transaction:
- by validating the operations performed (SQLTransaction(sqlCommit)).
- by canceling the operations performed (SQLTransaction(sqlRollBack)).

Nesting transactions

The transactions can be nested.

Native MySQL Connector

SQLLock and SQLTransaction are used to manage the locks and transactions on the MySQL "innoDB" tables.

Component : wd260hf.dll