|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Duplicates the record read in a table: the record found in memory is added into the table (query or view). |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Used to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Returns the list of items:
found in a table (a query or a view) known to the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
found in a Record variable.... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "normal" records if they 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|