|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current database schema or in a specific database schema. |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Returns:
the number of the current record in the HFSQL table.
the number of the current record in the HFSQL view.... |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a table. |
|
|
|
|
|
|
|
| Returns:
the number of elements in a one-dimensional array.
the number of rows in a two-dimensional array.
the number of elements in the first dimension of a three-dimensional or N-dimensional array.... |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the table is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table. |
|
|
|
|
|
|
|
| Positions on the first record of the table whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
| Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.). |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Returns the number of records in an HFSQL file, query or view: active records, deleted records, etc. |
|
|
|
|
|
|
|
| Declares a description of table (found in a database schema) in the current project. |
|
|
|
|
|
|
|
| Changes the password of an HFSQL Classic or HFSQL Client/Server table.... |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the table, view, query, ...). |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL table. |
|
|
|
|
|
|
|
| Returns the number of cards or lists in a Kanban control. |
|
|
|
|
|
|
|
| Sets the position on the first record according to a browse item. |
|
|
|
|
|
|
|
| Modifies the current record if it exists, otherwise adds a new record. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Unlocks a record locked by:
HLockRecNum,
a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).... |
|
|
|
|
|
|
|
| Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|