|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
|
| WDOptimizer is used to ... |
|
|
|
|
|
|
|
| The USE ... IN statement is used to define the block of operations to be performed in a transaction. |
|
|
|
|
|
|
|
| This chapter covers the following topics... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Determines whether a transaction was interrupted (the transaction was neither committed nor rolled back). |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Used to find out whether a transaction is in progress. |
|
|
|
|
|
|
|
| Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| If a transaction is active, rolls back all changes made to the tables since the beginning of the transaction. |
|
|
|
|
|
|
|
| Sets to a normal state all records that do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| If a transaction is active, rolls back all changes made to the tables since the beginning of the transaction. |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code... |
|
|
|
|
|
|
|
| When using a database, you may have to perform maintenance operations on the data files... |
|
|
|
|
|
|
|
| The HFSQL engine proposes to isolate the transactions... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| The different operations that can be performed with WDOptimizer are as follows ... |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number... |
|
|
|
|
|
|
|
| You have the ability to create applications that access the HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to create a query based on the data files of the database... |
|
|
|
|
|
|
|
| Copies a registry key with all its subkeys and values. |
|
|
|
|
|
|
|
| Usage example of the SQLTransaction function |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQLite... |
|
|
|
|
|
|
|
| When starting the iOS application, checks whether the In-App subscriptions have been renewed. |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code...... |
|
|
|
|
|
|
|
| The replication between HFSQL servers consists in automatically replicating the data from server... |
|
|
|
|
|
|
|
| Performs a reconnection to the server for all the interrupted connections. The uninterrupted... |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Renames a key in the registry. |
|
|
|
|
|
|
|
| Remarks and specific features of the Native Oracle Connector... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|