|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A Data Source variable is used to describe a temporary data source (query, view, alias, etc.). |
|
|
|
|
|
|
|
| MySource is used to handle the current data source (file, view or query) associated with a report or with a table based on a data file... |
|
|
|
|
|
|
|
| Determines if a data source has been initialized. |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| Determines if a data source has been initialized. |
|
|
|
|
|
|
|
| Defines the password used to create or open a table. |
|
|
|
|
|
|
|
| Initializes:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|