|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Subscribes to a Redis broadcast channel. |
|
|
|
|
|
|
|
| Checks the validity of a French SIREN number (Système d'Identification du Répertoire des... |
|
|
|
|
|
|
|
| Displays a "Toast" message. |
|
|
|
|
|
|
|
| Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| Returns the value of a record item when a modification conflict occurs.. |
|
|
|
|
|
|
|
| Opens a connection to a Redis server (or cluster). |
|
|
|
|
|
|
|
| Modifies the current record if it exists, otherwise adds a new record. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL data file and returns... |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Refreshes a user's OAuth2 token when it expires.... |
|
|
|
|
|
|
|
| Returns an array corresponding to the intersection of two arrays. |
|
|
|
|
|
|
|
| Shuffles the elements of a WLanguage array. |
|
|
|
|
|
|
|
| Returns an array without duplicates. |
|
|
|
|
|
|
|
| Deletes the duplicates from an array. |
|
|
|
|
|
|
|
| Returns an array corresponding to the union of two arrays. |
|
|
|
|
|
|
|
| Returns an array corresponding to the union of two arrays (without deleting duplicates). |
|
|
|
|
|
|
|
| Adds a row in:
a Table control,
a TreeView Table control.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|