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 ErrorInfo.
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.
Reports and QueriesHFSQLHFSQL Client/ServerHyper 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 enhance the cause of the error, by performing a simple browse between the different sub-errors for example (see the example).
The main functions generating sub-errors are: HCreateView, HExecuteView, HViewToFile, ...
Business / GUI classification : Business Logic
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment