|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector... |
|
|
|
|
|
|
|
| The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV... |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL... |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure.... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server data files...... |
|
|
|
|
|
|
|
| The File Description variable is used to programmatically describe data files. |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must... |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| The development in "3-tier" architecture is now simplified...... |
|
|
|
|
|
|
|
| The project description window allows you to configure various elements of your project...... |
|
|
|
|
|
|
|
| A Data source variable is used to describe a temporary data source (query, view, alias, ...) |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions.... |
|
|
|
|
|
|
|
| The httpRequest type is used to retrieve the advanced characteristics of an HTTP/HTTPS request.... |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL... |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file... |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported... |
|
|
|
|
|
|
|
| The restRequest type is used to define the advanced characteristics of a REST request. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to directly import Webservices into your applications...... |
|
|
|
|
|
|
|
| WEBDEV Tutorial - Managing an HFSQL Client/Server database Lesson 1 - Implementing a Client/Server... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|