Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • HFSQL error numbers
  • Managing the sub-errors
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Returns the number of the last error triggered by the HFSQL engine.
Remark: This function must be called just after the function that failed. Calling a function other than an error function can reinitialize or change the status report returned by HError.
// Manage an error wile creating a file
IF HCreation(Customer) = False THEN
Error("HFSQL error: " + HError())
<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.
(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.

JavaPHP This parameter is ignored.

HFSQL error numbers

To find out the main numbers of HFSQL errors, see: HFSQL errors.
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadJavaUser code (UMC)AjaxHFSQL ClassicHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBNative Connectors (Native Accesses)

Managing the sub-errors

Several functions generate two levels of error. 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: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help