|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding table. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| Releases query resources (following use of HExecuteQuery or HExecuteSQLQuery functions). |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL table, from a query or from an HFSQL view into a physical file (on disk). |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the table (query or view).
the record found in a Record variable into the table (query or view).... |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the table (query or view). |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Creates a logical alias of a table (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Enables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Transforms the crossed records (HCross) into deleted records. |
|
|
|
|
|
|
|
| List of constants used by the functions for port management (serial and parallel ports)... |
|
|
|
|
|
|
|
| Changes the mode and the method for locking tables. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server table.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|