|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A global procedure can be used in all the processes or events of the project. |
|
|
|
|
|
|
|
| A procedure is used to associate an identifier with a statement block... |
|
|
|
|
|
|
|
| You have the ability to pass parameters to a procedure. |
|
|
|
|
|
|
|
| The different syntaxes for declaring a procedure... |
|
|
|
|
|
|
|
| Syntax for calling a local or global procedure. |
|
|
|
|
|
|
|
| The MyParameters keyword is used to handle the parameters passed to a WLanguage procedure... |
|
|
|
|
|
|
|
| Two types of procedures are available... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The procedures and the methods of classes can have several syntaxes. |
|
|
|
|
|
|
|
| The parameters can be passed to a procedure... |
|
|
|
|
|
|
|
| Enables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical... |
|
|
|
|
|
|
|
| Closes the current analysis. |
|
|
|
|
|
|
|
| Closes a connection to a database. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation... |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a 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. |
|
|
|
|
|
|
|
| Begins, commits or rolls back a transaction:
on the files of a database opened by SQLConnect,... |
|
|
|
|
|
|
|
| Forces the operating system of the computer where the data files are found to write data onto... |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo... |
|
|
|
|
|
|
|
| Modifies the group information according to the elements found in the corresponding variables... |
|
|
|
|
|
|
|
| Positions on the next row of the query result. |
|
|
|
|
|
|
|
| Modifies the information about a user according to the elements found in the corresponding... |
|
|
|
|
|
|
|
| Checks the existence of a query. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Positions on the previous row of the query result. |
|
|
|
|
|
|
|
| Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|