|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| Automatically initializes the controls of a window with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Changes the path to a table (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Stops watching a table on an HFSQL server. |
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Creates an HFSQL view.
This function uses the former view mechanism.... |
|
|
|
|
|
|
|
| Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Compares two values by sorting them according to the specified HFSQL index sort item: all sort options specified for the sort item are taken into account (case sensitivity, punctuation, sort direction, Unicode language, ...). |
|
|
|
|
|
|
|
| Retrieves the structure and value of the current record and exports them into a string in JASON format. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Adds comments to the log when saving the operation. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|