|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Validates the current transaction:
the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
the records locked in read-only by the transaction are unlocked.... |
|
|
|
|
|
|
|
| Sets the position on the first record according to a browse item. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Sends a specific FTP command to a server. |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| 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 last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Stores the current file context: current record, filter, pointers. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Usage example of the HReadSeek function |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Used to find out the number of records added, modified or deleted when running the last query of the current context. |
|
|
|
|
|
|
|
| Usage example of the HForward function |
|
|
|
|
|
|
|
| Usage example of the HSetPosition function |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Usage example of the HReadSeekFirst function |
|
|
|
|
|
|
|
| Usage example of the HLinkMemo function |
|
|
|
|
|
|
|
| Usage example of the HCreateView function |
|
|
|
|
|
|
|
| The Source property can be used on:
a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ...
a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Usage example of the HExtractMemo function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|