|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Changes the mode and the method for locking tables. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Unlocks the records of a table:
locked by HLockFile.
individually locked by a locking read function.... |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside the table, filter, view or query. |
|
|
|
|
|
|
|
| Imports a Text file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Creates an empty table (extension ".FIC") with index file, full-text index file, spatial index file, and memo file if required. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
| Modifies the physical name of a table. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|