|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL table... |
|
|
|
|
|
|
|
| There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| An HFSQL application can operate in network mode or in Client/Server mode... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| You have the ability to create applications that access the HFSQL Client/Server databases... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors... |
|
|
|
|
|
|
|
| Starting with version 2024, you can store and manipulate geometric and geographic data in HFSQL databases... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| The "Key" items are used to organize the records in a table in order to optimize the browse or the search... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| The database schema proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| An HFSQL context contains information relative to the data used... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view... |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| Recreates the subscriber replica description file (universal replication only) based on the information of the master replica (.rpm and .syn files). |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Link functions are used to link the interface with the tables and vice versa. These functions are as follows: |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL table. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| WDHFDiff is a tool used to compare HFSQL tables... |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more tables. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Creates the description file of a Master Replica (logged replication or universal replication). |
|
|
|
|
|
|
|
| A Link Description variable is used to describe a link between two tables programmatically. |
|
|
|
|
|
|
|
| Describes a full-text index of table created programmatically. |
|
|
|
|
|
|
|
| The Alias type is used to declare and handle a logical alias for a table or query. |
|
|
|
|
|
|
|
| Returns the value of a record item when a modification conflict occurs..
|
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL table. |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Returns the list of semantic keys present in a table, query or view supported by the HFSQL engine. |
|
|
|
|
|
|
|
| After the execution of a read or write function in a table, used to find out whether an error caused by a wrong password occurred on this table.
|
|
|
|
|
|
|
|
| Stores the current context of a table: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Crosses a record in a table. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
| Imports a CSV file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Crosses a record in a table. |
|
|
|
|
|
|
|
| Determines whether a transaction was interrupted (the transaction was neither committed nor rolled back). |
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| REP files contain the list of tables handled by the application. |
|
|
|
|
|
|
|
| Imports a Text file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
|
| Sets the position on the first record of the table whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| Defines a semantic index of a table created programmatically. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| The aliases are used to handle ... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Remarks and specific features of Native PostgreSQL Connector... |
|
|
|
|
|
|
|
| Closes one or all the tables opened by the current user. |
|
|
|
|
|
|
|
| Imports a CSV file into an HFSQL Classic or Client/Server table. This table 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. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Returns the list of WINDEV or WEBDEV database schemas (in HFSQL Classic format) available in a given directory. |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
|
| The comparison operators can be divided into several categories... |
|
|
|
|
|
|
|
| Determines whether a transaction is active. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| A log is a special file that contains the history of all changes made to one or more tables over a given period of time (date the table was created, last automatic data modification, last backup created with WDLog, etc.) |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| A filter is used to define programmatically a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
Returns the list of table bindings (Merise type) present:- in the current database schema,
- in ongoing database schemas (projects with multiple database schemas).
- in a specific database schema.
|
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table.
|
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside the table, filter, view or query. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current database schema or in a specific database schema. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the table, according to a specified item. |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL table and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Used to check whether an integrity error occurred. |
|
|
|
|
|
|
|
| Deletes a record from a table (query or view). |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Sets to a normal state all records that do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL table and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more tables. |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| Stops the log process of a file. |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Describes a link between two tables programmatically. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Returns a detailed information about the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the table, according to a specified item. |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL tables. |
|
|
|
|
|
|
|
| Stops the log process of a file. |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the table according to a browse item. |
|
|
|
|
|
|
|
| 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 tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Sets the position on the first record of the table whose value for a specific item is greater than or equal to the search value (generic search). |
|
|
|
|
|
|
|
| Sets the position on the first record of the table whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
| Used to find out whether the record on which you want to be positioned is located outside the table, filter, view or query. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
Unlocks the records of a table:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Returns the number of the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| A composite key is a key item containing several other items... |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Unlocks the records of a table:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Enables or disables the management of triggers. |
|
|
|
|
|
|
|
| An Item Description variable is used to describe one or more items in a table programmatically. |
|
|
|
|
|
|
|
| Returns the list of items: |
|
|
|
|
|
|
|
| Used to check whether a duplicate error occurred. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Sets the position on the first record of the table whose value for a specific item is greater than or equal to the search value (generic search). |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| Deletes a record from a table (query or view). |
|
|
|
|
|
|
|
Allows you to: - return the value of a record item if a modification conflict occurs.
- check if a modification conflict occurred.
|
|
|
|
|
|
|
|
| Imports a Text file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Closes one or all the tables opened by the current user. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| A "spare" server is a target server in a unidirectional automatic replication... |
|
|
|
|
|
|
|
| Link functions are used to link the interface with the tables and vice versa. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table.
|
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Imports an XLS file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL tables specified by the user when installing the application. |
|
|
|
|
|
|
|
| The File Description variable is used to programmatically describe tables. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| This document presents the different access modes to databases from a WINDEV Java application... |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm... |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
|
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| 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 whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Returns the list of semantic indexes for a table supported by the HFSQL engine. |
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
|
| Closes the current database schema or all current database schemas. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the table according to a browse item. |
|
|
|
|
|
|
|
| Usage example of the HExtractMemo function |
|
|
|
|
|
|
|
| The Description of ParallelTask type is used to define the characteristics of a parallel task. |
|
|
|
|
|
|
|
| The automatic data file modification updates the description of data files on user computers...... |
|
|
|
|
|
|
|
| Usage example of the HCopyRecord function |
|
|
|
|
|
|
|
| Usage example of the HLinkMemo function |
|
|
|
|
|
|
|
| Usage example of the HCreateView function |
|
|
|
|
|
|
|
| Usage example of the HReadSeekFirst function |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Usage example of the HCreationIfNotFound function |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user... |
|
|
|
|
|
|
|
| Contains the number of the physical record loaded in memory (which means the number of the last... |
|
|
|
|
|
|
|
| The automatic table modification updates the description of tables on user computers...... |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| Starts the execution of a secondary thread. |
|
|
|
|
|
|
|
| Automatically initializes the values of the members of a structure or class with the values... |
|
|
|
|
|
|
|
| Usage example of the HCopyFile function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|