ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • HFSQL error numbers
  • Managing the sub-errors
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
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 HCreate(Customer) = False THEN
	Error("HFSQL error: " + 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.

Java This parameter is ignored.
Remarks

HFSQL error numbers

To get the main HFSQL error numbers, see: HFSQL errors.
WINDEVUniversal Windows 10 AppJavaUser code (UMC)HFSQL 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: 06/14/2024

Send a report | Local help