|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the first record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal... |
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal... |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought... |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Updates on the server all the links of an HFSQL Client/Server data file.... |
|
|
|
|
|
|
|
| Changes the mode and the method for locking data files. |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the data file (query or view). |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL data file by performing an automatic data modification... |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records,... |
|
|
|
|
|
|
|
| Defines the password used to create or open a data file. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next... |
|
|
|
|
|
|
|
| Initialize:
one or all variables of file items with their default values.
one or all items... |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Starts tracking write actions (addition, modification or deletion) performed on a file found... |
|
|
|
|
|
|
|
| Stops tracking a data file on an HFSQL server. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|