|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of items in a table (query or view) recognized by the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. |
|
|
|
|
|
|
|
| Returns:
the number of columns found in a Table or TreeView Table control.
the number of rows found in a Table or TreeView Table control.... |
|
|
|
|
|
|
|
| Changes the path to a table (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Used to find out:
whether the content of a file was modified.
whether the content of a file used by a query was modified.... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|