|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| Defines the password used to create or open a data file. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initialize:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server. |
|
|
|
|
|
|
|
| Stops tracking a data file on an HFSQL server. |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example). |
|
|
|
|
|
|
|
| Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL data file. |
|
|
|
|
|
|
|
| Assigns the specified value to an item of the current record. |
|
|
|
|
|
|
|
| Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the list of links (Merise type) found in the current analysis or in a specific analysis. |
|
|
|
|
|
|
|
| Returns the value of a record item when a modification conflict occurs.. |
|
|
|
|
|
|
|
| Modifies the current record if it exists, otherwise adds a new record. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|