- Operating mode of custom errors
- Using a class method to customize the errors
- Customizing the default error windows
- Customizing the default error pages
In french: HSurErreur
Not available with this kind of connection
Customizes the management of HFSQL errors.
WINDEV, WEBDEV and WINDEV Mobile propose an automatic management of errors. The automatic management of errors can be disabled or enabled for one or more data files, for one or more types of errors. To do so, use HOnError
and specify an empty string for the name of window, page or procedure. See Assisted management of HFSQL errors
for more details.
The management of HFSQL errors must be programmed by HOnError
. The management of HFSQL errors is not automatically taken account. HOnError
is used to customize the management of HFSQL errors by running a specific procedure or window for example.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
<Result> = HOnError(<Data file> , <Type of error> [, <Procedure/window/page>])
- True if the operation was successfully performed,
- False otherwise. HError returns more details about the problem.
<Data file>: Character string (with or without quotes)
Name of data file used. If this parameter is equal to "*" the customization will be applied to all data files found in the analysis or defined by programming.
<Type of error>: Constant or combination of constants
Type of error to configure.
<Procedure/window/page>: Optional character string
- Name of window or procedure to call when a <Type of error> error occurs.
- Name of object method if HOnError is called in a method of this object.
Versions 20 and later Name of procedure to call when a <Type of error> error occurs. New in version 20 Name of procedure to call when a <Type of error> error occurs. Name of procedure to call when a <Type of error> error occurs.
- Parameter not specified. If "Enable the automatic HFSQL help" is checked in the project, the default window or page for automatic management of errors is used for the specified type of error and for the specified data file.
- Empty string. In this case, the automatic management of errors will be disabled.
Remark: To disable the automatic management of errors, you also have the ability to uncheck "Enable the automatic HFSQL help" in the project.
Remark: In some cases (loss of connection errors for example), the procedure/window/page will be run during the next call to the WLanguage function following the event that triggered the error.
Special case: using a window, a page or a procedure found in a component
Only some of the windows/pages for the automatic management of errors are available. The automatic management of errors is disabled for these errors.
: The following syntax must be used:
HOnError(<Data file>, <Type>, ...
"<Component>.<Name of set of procedures>.<Procedure name>")
HOnError(<Data file>, <Type>, "<Component>.<Window name>")
HOnError(<Data file>, <Type>, "<Component>.<Page name>")
If a loss of connection occurs, to ask for reconnection, this procedure must call HReconnect
Operating mode of custom errors
The procedure, window or page used to customize the error must return one of the following constants:
|opRetry||The function that triggered the error is re-run.|
|opCancel||The function that triggered the error returns an error as if the assisted management was disabled. |
Remark: For the errors of loss of connection, the error is fatal.
|opEndProcess||The function that triggered the error returns an error and the current process stops. Equivalent to the following code line:|
IF NOT <HFSQL function> THEN ReturnToCapture()
This constant is not available.
|opEndProgram||The function that triggered the error returns an error and the program stops. Equivalent to the following code line:|
IF NOT <HFSQL function> THEN EndProgram()
|opRelaunchProgram||The program stops and the application is automatically restarted.
This constant is not available.
If a loss of connection occurs, to ask for reconnection, HReconnect
must be used in the procedure called by HOnError
Using a class method to customize the errors
<Name of procedure or window> can also correspond to a method of an object if HOnError is called in a method of this object. All you have to do is specify the name of the method to use (without using the object name as prefix).
When the method is called by the HFSQL engine, a fatal error occurs if the object used during the call to HOnError is no longer created.
Customizing the default error pages
The default error pages are supplied (as well as their WLanguage code) for information in the "\Programs\Data\Preset pages\HFSQL - Automatic help pages" directory.
These pages can be included in your projects, customized and passed in parameter to HOnError.
Training (WINDEV): WD Managing HFSQL Errors
This page is also available for…