|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Performs the following operations:
If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
If the file exists, opens the file.... |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Transforms all the records "in transaction" into "Normal" records if these records do not belong to a transaction currently in progress. |
|
|
|
|
|
|
|
| In a Table control, you have the ability to customize the following elements...... |
|
|
|
|
|
|
|
| Returns the list of keys found in a file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current analysis or in a specific analysis |
|
|
|
|
|
|
|
| Returns the list of items:
found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
found in a Record variable.... |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| List of video functions... |
|
|
|
|
|
|
|
| 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 data file according to a browse item. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Usage example of the fSeek function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|