|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Cancels the current search criterion. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table 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. |
|
|
|
|
|
|
|
| Returns the number of entries for a given key item. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Defines and enables a "Contains" 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.... |
|
|
|
|
|
|
|
| Defines the password used to create or open a table. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Duplicates the record read in a table: the record found in memory is added into the table (query or view). |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL table by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Stores the current context of a table: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Imports JSON data into the current record. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Imports an XML 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).... |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL table. |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more tables. |
|
|
|
|
|
|
|
| Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|