|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user. |
|
|
|
|
|
|
|
| Used to find out:
whether the content of a file was modified.
whether the content of a file used by a query was modified.... |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of items in a table (query or view) recognized by the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. |
|
|
|
|
|
|
|
| Changes the path to a table (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Unlocks a record locked by:
HLockRecNum,
a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).... |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Stops watching a table on an HFSQL server. |
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Creates an HFSQL view.
This function uses the former view mechanism.... |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). |
|
|
|
|
|
|
|
| Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|