|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| An HFSQL context contains information relative to the data used... |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Describes a full-text index of table created programmatically. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| Returns the list of items: |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| WDHFDiff is a tool used to compare HFSQL tables... |
|
|
|
|
|
|
|
| This document presents the different access modes to databases from a WINDEV Java application... |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a table. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm... |
|
|
|
|
|
|
|
| Link functions are used to link the interface with the tables and vice versa. These functions are as follows: |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL tables specified by the user when installing the application. |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| The File Description variable is used to programmatically describe tables. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| The comparison operators can be divided into several categories... |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| A filter is used to define through programming a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Training FOR ALL instruction can be used to perform different types of runs... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled). |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical... |
|
|
|
|
|
|
|
| Assigns the specified value to an item of the current record. |
|
|
|
|
|
|
|
| Unlocks the records of a data file:
locked by HLockFile.
individually locked by a locking... |
|
|
|
|
|
|
|
| Unlocks a record locked by:
HLockRecNum,
a read function used with a locking parameter (HRead... |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation... |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal... |
|
|
|
|
|
|
|
| Immediately runs a scheduled task regardless of its schedule:
stored procedure,
backup,... |
|
|
|
|
|
|
|
| Used to check whether an integrity error occurred. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to directly generate web services that use the SOAP technology...... |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation... |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal... |
|
|
|
|
|
|
|
| The wizard for window creation proposes several types of windows associated with HFSQL data... |
|
|
|
|
|
|
|
| Immediately runs a scheduled task regardless of its schedule:
stored procedure,
backup,... |
|
|
|
|
|
|
|
| Locks a data file and restricts the access to this data file for all other sites or applications. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|