|
|
|
|
|
- Operating mode of custom errors
- Using a class method to customize the errors
- Customizing the default error windows
- Customizing default error pages
HOnError (Function) 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. For more details, see HFSQL error handling help.
Syntax
<Result> = HOnError(<Data file> , <Type of error> [, <Procedure/window/page>])
<Result>: Boolean - True if the operation was successfully performed,
- False otherwise. HError returns more details about the problem.
<Data file>: Character string Name of the data file used. If this parameter is equal to "*" the customization will be applied to all data files found in the analysis or defined programmatically. <Type of error>: Constant or combination of constants Type of error to configure. | | hErrAll | Configure all previous errors (except hErrIndex).
| hErrConnectionLoss | Configure the errors caused by a loss of connection with the HFSQL server. | hErrDatabaseAccess | Configures the access errors to an HFSQL Client/Server database (access forbidden by HNoDatabaseAccess).
| hErrDuplicates | Configure duplicate errors.
| hErrIndex | Configures indexing errors (reindexing in progress during the file access).
| hErrIntegrity | Configure integrity errors.
| hErrLock | Configure lock errors.
| hErrModify | Configure a modification conflict.
| hErrNeedValue | Configure errors caused by a required value that has not been specified (OLE DB and some Native Connectors).
| hErrPassword | Configure password errors (wrong password).
|
<Procedure/window/page>: Optional character string Corresponds to: - Name of object method if HOnError is called in a method of this object.
- 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.
Note: To disable automatic error handling, you can also uncheck the project option "Enable HFSQL automatic assistance"..
Note: In some cases (e.g. lost connection errors), the procedure/window/page will only be executed on the next call to the WLanguage function following the event causing the error..
Special case: use of a window, page or Procedure Component: The following syntax must be used: Procedure:
HSurErreur(<Fichier de données>, <Type>, ... "<Composant>.<Nom de la Collection de procédures>.<Nom de la procédure>")
Window:
HSurErreur(<Fichier de données>, <Type>, "<Composant>.<Nom de la fenêtre>") Page:
HSurErreur(<Fichier de données>, <Type>, "<Composant>.<Nom de la page>") Remarks Operating mode of custom errors The procedure, window or page used to customize the error must return one of the following constants: | | opCancel | The function that triggered the error returns an error as if the assisted management was disabled. Note: For lost connection errors, the error is fatal. | opEndProcess | The function that triggered the error returns an error and the current process stops. Equivalent to the following line of code:
SI PAS <Fonction HFSQL> ALORS DonneFocusEtRetourUtilisateur() | opEndProgram | The function that triggered the error returns an error and the program stops. Equivalent to the following line of code:
SI PAS <Fonction HFSQL> ALORS FinProgramme() | opRelaunchProgram | The program stops and the application is automatically restarted.
| opRetry | The function that triggered the error is re-run. |
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). A fatal error occurs if the object used in the call to HOnError is no longer allocated when the HFSQL engine calls the method
Related Examples:
|
Training (WINDEV): WD Managing HFSQL Errors
[ + ] The "WD Managing HFSQL Errors" example presents the management of HFSQL errors (duplicate, integrity). This example explains how to customize the process when an error occurs.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|