|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Usage example of the HCreateView 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 HSetPosition 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.).... |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Usage example of the HExtractMemo function |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| ODBCSQLCode is used to:
Find out the SQL code of the "query performed on a connection" (data source of report).
Modify the SQL code of the "query performed on a connection" (data source of report).... |
|
|
|
|
|
|
|
| ODBCDatabaseName is used to:
Find out the name of the database used when printing a report based on a "query performed on a connection".
Specify the name of the database used when printing a report based on a "query performed on a connection".... |
|
|
|
|
|
|
|
| The ODBCConnectionName property is used to:
Identify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".... |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Usage example of the HListKey function |
|
|
|
|
|
|
|
| Usage example of the HFileExist function |
|
|
|
|
|
|
|
| Usage example of the HErrorInfo function |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|