|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Usage example of the HCreateView function |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Usage example of the HExtractMemo function |
|
|
|
|
|
|
|
| Usage example of the HLinkMemo function |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| Usage example of the HListKey function |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed by other computers.
The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... |
|
|
|
|
|
|
|
| If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL data files. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Usage example of the HFileExist function |
|
|
|
|
|
|
|
| Usage example of the HErrorInfo function |
|
|
|
|
|
|
|
| Usage example of the HNbRec function |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|