PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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. Indeed, the call to a function (other than an error function) can reinitialize and modify 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.
// 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.
hSubErrNextNumber of the next sub-error.
hSubErrLastNumber of the last sub-error.
hSubErrPreviousNumber of the previous sub-error.
Remarks

HFSQL error numbers

To find out the main numbers of HFSQL errors, see: the HFSQL errors.
iPhone/iPadUniversal Windows 10 AppWindows MobileHFSQLHFSQL Client/ServerStored proceduresNative 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 : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment