ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • HFSQL error numbers
  • Managing the sub-errors
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the number of the last error triggered by the HFSQL engine.
Remark: This function must be called immediately after the failed function call.. Calling a function other than an error function can reinitialize or change the status report returned by HError.
// Gestion d'une erreur lors de la création d'un fichier
IF HCreation(Client) = False THEN
	Error("Erreur HFSQL: " + HError())
END
Syntax
<Result> = HError([<Type of error>])
<Result>: Integer
  • Number of the last error that occurred.
  • hNoError constant (set to 0) in the following cases:
    • No error occurred.
    • The requested type of error corresponded to a sub-error but no sub-error occurred.
<Type of error>: Optional integer constant.
Used to retrieve the numbers of sub-errors.
hErrCurrent
(default value)
Number of the current error.
hErrMainNumber of the main error.
hSubErrFirstNumber of the first sub-error.
hSubErrLastNumber of the last sub-error.
hSubErrNextNumber of the next sub-error.
hSubErrPreviousNumber of the previous sub-error.

PHP This parameter is ignored.
Remarks

HFSQL error numbers

For the main HFSQL error numbers, see: HFSQL errors.
WEBDEV - Server codeAjaxHFSQL ClassicHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBNative Connectors (Native Accesses)

Managing the sub-errors

Several functions generate two levels of errors. These two error levels are used to narrow down the cause of the error, for example by performing a simple browse between the different sub-errors (see example).
The main functions generating sub-errors are: HCreateView, HExecuteView, HViewToFile, ...
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help