|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. 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... |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). 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... |
|
|
|
|
|
|
|
| You have the ability to create applications that access the HFSQL Client/Server databases... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| Starting with version 2024, you can store and manipulate geometric and geographic data in HFSQL databases... |
|
|
|
|
|
|
|
| The analysis proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| An HFSQL application can operate in network mode or in Client/Server mode... |
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
| The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... |
|
|
|
|
|
|
|
| There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file... |
|
|
|
|
|
|
|
| The "Key" items are used to organize the records in a data file in order to optimize the browse or the search... |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Closes one or all the data files opened by the current user. |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the first record of the data file whose value for a specific item is greater than or equal to the search value (generic search). |
|
|
|
|
|
|
|
| Defines a semantic index of a data file created programmatically. |
|
|
|
|
|
|
|
| A composite key is a key item containing several other items... |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| Sets the position on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item matches exactly the search value (exact-match search). |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets to a normal state all records that do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Stops the log process of a file. |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Determines whether a transaction was interrupted (the transaction was neither committed nor rolled back). |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| A Link Description variable is used to describe a link between two data files programmatically. |
|
|
|
|
|
|
|
| A filter is used to define programmatically a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| 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 data file. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| The aliases are used to handle ... |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Stops the log process of a file. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Returns the list of semantic indexes for a data file supported by the HFSQL engine. |
|
|
|
|
|
|
|
| Closes the current analysis or all current analyses. |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL data file. |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| Returns the list of semantic keys present in a data file, query or view supported by the HFSQL engine. |
|
|
|
|
|
|
|
| Describes a link between two data files programmatically. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| An Item Description variable is used to describe one or more items in a data file programmatically. |
|
|
|
|
|
|
|
| Determines whether a transaction is active. |
|
|
|
|
|
|
|
| Describes a full-text index of data file created programmatically. |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| Closes one or all the data files opened by the current user. |
|
|
|
|
|
|
|
| The File Description variable is used to programmatically describe data files. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| Sets the position on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of WINDEV or WEBDEV analyses (in HFSQL Classic format) available in a given directory. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Sets the position on the first record of the data file whose value for a specific item is greater than or equal to the search value (generic search). |
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
The FOR EACH statement is used to perform different types of HFSQL browse:- Full loop (according to a specified key or not)
- Loop with filter (simple filter, filter on a key or filter on the search key). Filters then accept the operators of the HFilter function.
|
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal to the search value (exact-match search). |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|