ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

<Connection variable>.Transaction (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
WDOptimizer: Roll back / release transaction records
WDOptimizer is used to ...
USE IN (transaction)
The USE ... IN statement is used to define the block of operations to be performed in a transaction.
Transactions: Secure your processes on HFSQL tables
This chapter covers the following topics...
<Source>.TransactionFree (Function)
Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction.
<Connection variable>.TransactionEnd (Function)
Validates the current transaction:
  • the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
HTransactionInterrupted (Function)
Determines whether a transaction was interrupted (the transaction was neither committed nor rolled back).
HTransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
<Connection variable>.TransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
Starting WDOptimizer in a command line
The wizard for creating iPad windows allows you to easily create a window containing all the main elements of a window for an iPad application...
SQLTransaction (Function)
Begins, commits or rolls back 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) defined in the data model editor or with HOpenConnection.
HTransactionSavepoint (Function)
Declares a transaction savepoint.
HTransactionInProgress (Function)
Used to find out whether a transaction is in progress.
<Connection variable>.TransactionIsolation (Function)
Configures the isolation level of transactions for a connection to an HFSQL server.
HTransaction (Function)
Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table.
HSetTransaction (Function)
Enables or disables the management of transactions for one or more files.
HTransactionCancel (Function)
If a transaction is active, rolls back all changes made to the tables since the beginning of the transaction.
HTransactionFree (Function)
Sets to a normal state all records that do not belong to an ongoing transaction.
<Connection variable>.TransactionCancel (Function)
If a transaction is active, rolls back all changes made to the tables since the beginning of the transaction.
Transactions in SQL
Starting with version 21, you can manage transactions in SQL code...
Maintaining the files of Control Centers
When using a database, you may have to perform maintenance operations on the data files...
Client/Server transactions: available isolation modes
The HFSQL engine proposes to isolate the transactions...
HTransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table.
HTransactionEnd (Function)
Validates the current transaction:
  • the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
<Source>.SetTransaction (Function)
Enables or disables the management of transactions for one or more files.
Transactions in HFSQL Client/Server mode
To keep maximum compatibility between HFSQL Classic applications (single-user or multi-user) and HFSQL Client/Server applications, the transaction mechanism in HFSQL Client/Server mode is similar to the one in HFSQL Classic mode...
HTransactionIsolation (Function)
Configures the isolation level of transactions for a connection to an HFSQL server.
WDOptimizer: Presentation
The different operations that can be performed with WDOptimizer are as follows ...
<Connection variable>.TransactionSavepoint (Function)
Declares a transaction savepoint.
<Connection variable>.TransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
HCopyFile (Function)
Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any): from the HFSQL server...
HFSQL Control Center: Overview
The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile,...
Managing HFSQL Classic data files
The HFSQL Control Center allows you to fully manage HFSQL Classic data files......
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
FTPConnect (Function)
Connects the current computer to an FTP server (File Transfer Protocol).
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Android In-App configuration
A specific configuration is required to manage the In-App purchases in an Android application......
Optional connection information
When defining the connections in the data model editor or when defining the connections...
17. TLS/SSL: Encrypting information on the Web
xBase/FoxPro Native Access: Features and notes
This help page presents the specific features regarding the programming of Native xBase/FoxPro...
3-tier architecture
The development in "3-tier" architecture is now simplified......
WDInst: installing additional elements
By default, only the files found in the "List of setup files" window are installed on the user...
WINDEV, WEBDEV and WINDEV Mobile tools
The following tools are provided with WINDEV, WEBDEV and WINDEV Mobile...
In-App purchases
The mobile systems (Android/iOS) allow their applications to propose content at extra cost,...
How to include secure payment in a WEBDEV site?
This help page explains how to add a secure payment into a WEBDEV site......
Modifying the query content
The queries are used to easily select the records coming from one or more files, matching one...
1
5
6
7
8
9
12
>