|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 specified result row of the query. |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Modifies the content of a row in the query result. |
|
|
|
|
|
|
|
| Enables or disables the management of .REP file. |
|
|
|
|
|
|
|
| Retrieves the content of a Text Memo column found in the query result, for the current line. |
|
|
|
|
|
|
|
| Temporarily disables (or re-enables) the replication. |
|
|
|
|
|
|
|
| Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Enables or disables the management of triggers. |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file.... |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described... |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server data file (data file described... |
|
|
|
|
|
|
|
| Returns the different types of columns supported:
by the data source identified by SQLConnect... |
|
|
|
|
|
|
|
| Returns the characteristics of binary and text memos. |
|
|
|
|
|
|
|
| Declares the end of the query execution and frees the memory resources allocated... |
|
|
|
|
|
|
|
| Returns information about the specified replica. |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica... |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|