|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Syntax for calling a local or global procedure. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Two types of procedures are available... |
|
|
|
|
|
|
|
| The description of the parameter type is optional... |
|
|
|
|
|
|
|
| The procedures and the methods of classes can have several syntaxes. |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal... |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the data file, according to a specified... |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Stores the current file context: current record, filter, pointers. |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
| Positions on the first record of the data file whose value for a specific item is greater... |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval... |
|
|
|
|
|
|
|
| Returns the number of entries for a given key item. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing... |
|
|
|
|
|
|
|
| Defines the mode for comparing data files. |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description.... |
|
|
|
|
|
|
|
| Used to find out:
whether the content of a file was modified.
whether the content of a file... |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside... |
|
|
|
|
|
|
|
| Retrieves the structure and value of the current record and exports them into a string in JASON... |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view... |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical... |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|