|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The different syntaxes for declaring a procedure... |
|
|
|
|
|
|
|
| A global procedure can be used in all the processes or events of the project. |
|
|
|
|
|
|
|
| You have the ability to pass parameters to a procedure. |
|
|
|
|
|
|
|
| The parameters can be passed to a procedure... |
|
|
|
|
|
|
|
| When the procedure uses a variable number of parameters, you must be able to handle the different parameters passed to the function in the code of the procedure. |
|
|
|
|
|
|
|
| The description of the parameter type is optional... |
|
|
|
|
|
|
|
| Two types of procedures are available... |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Contains" filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Forces the operating system of the computer where the data files are found to write data onto... |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Returns the modifications performed on one or more items of a given record. The result can... |
|
|
|
|
|
|
|
| Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model... |
|
|
|
|
|
|
|
| Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described... |
|
|
|
|
|
|
|
| Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described... |
|
|
|
|
|
|
|
| Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file.... |
|
|
|
|
|
|
|
| Returns the characteristics of binary and text memos. |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica... |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one... |
|
|
|
|
|
|
|
| Adds comments to the log when saving the operation. |
|
|
|
|
|
|
|
| Used to re-create an empty log. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Stops the log process of a file. |
|
|
|
|
|
|
|
| Free the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|