|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| WDOptimizer is used to ... |
|
|
|
|
|
|
|
| The USE ... IN statement is used to define the block of operations to be performed in a transaction. |
|
|
|
|
|
|
|
| The various operations that can be carried out with WDOptimizer are ... |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all operations performed on data files in transactions since the start of the transaction. |
|
|
|
|
|
|
|
Validates the current transaction: - the modifications performed on the data file 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.
|
|
|
|
|
|
|
|
| When using a database, you may have to perform maintenance operations on the data files... |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| This chapter covers the following topics... |
|
|
|
|
|
|
|
| The HFSQL engine proposes to isolate the transactions... |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled). |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
Validates the current transaction: - the modifications performed on the data file 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.
|
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| If a transaction is active, rolls back all changes made to the data files since the beginning of the transaction. |
|
|
|
|
|
|
|
| Used to find out whether a transaction is in progress. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code... |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL servers...... |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native Sybase... |
|
|
|
|
|
|
|
| Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist):
from the HFSQL server... |
|
|
|
|
|
|
|
| For backward compatibility with the earlier versions of Native Oracle Connector (also called Native... |
|
|
|
|
|
|
|
| Sends an HTTP request and waits for the response from the HTTP server. |
|
|
|
|
|
|
|
| The method for creating an application supporting the switch to the Euro is as simple as the method... |
|
|
|
|
|
|
|
| During the connection to the remote HFSQL administrator, you must specify the HFSQL server... |
|
|
|
|
|
|
|
| Remarks and specific features of Native PostgreSQL Connector...... |
|
|
|
|
|
|
|
| The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile,... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Classic data files...... |
|
|
|
|
|
|
|
| Connects the current computer to an FTP server (File Transfer Protocol). |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| A specific configuration is required to manage the In-App purchases in an Android application...... |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections... |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user... |
|
|
|
|
|
|
|
| The following tools are provided with WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| The mobile systems (Android/iOS) allow their applications to propose content at extra cost,... |
|
|
|
|
|
|
|
| This help page explains how to add a secure payment into a WEBDEV site...... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one... |
|
|
|
|
|
|
|
| This help page presents the specific features regarding the programming of Native xBase/FoxPro... |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector...... |
|
|
|
|
|
|
|
| The setup wizard allows you to include additional modules in the setup. The additional modules... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|