|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Builds the value of a composite key to implement a filter (HFilter) or to perform a search... |
|
|
|
|
|
|
|
| Copies:
the content of the current record (loaded in memory) to the current data file record.... |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Returns the date and time that an HFSQL record was last modified (Classic or Client/Server).... |
|
|
|
|
|
|
|
| Declares a description of data file (found in an analysis) in the current project. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL... |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more data files. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used... |
|
|
|
|
|
|
|
| Retrieves the structure and the value of the current record and exports them into a character... |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation... |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server data file (data file described... |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format... |
|
|
|
|
|
|
|
| Returns:
the number of the current record in the HFSQL data file.
the number of the current... |
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries... |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order... |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|