|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Performs the following operations:
If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
If the table exists, opens the table.... |
|
|
|
|
|
|
|
| Crosses a record in a table. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL table. |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more tables. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the table (query or view).
the record found in a Record variable into the table (query or view).... |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding table. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| Imports JSON data into the current record. |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| Automatically updates the controls of a page 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.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Releases query resources (following use of HExecuteQuery or HExecuteSQLQuery functions). |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL table, from a query or from an HFSQL view into a physical file (on disk). |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the table (query or view). |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Creates a logical alias of a table (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|