PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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.
Versions 15 and later
Android This function is now available for Android applications.
New in version 15
Android This function is now available for Android applications.
Android This function is now available for Android applications.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Manage an error wile creating a file
IF HCreation(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.
JavaPHP This parameter is ignored.
Remarks

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)AjaxHFSQLHFSQL 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: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment