HError (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

HFSQL error numbers
Managing the sub-errors

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HError (Function)

In french: HErreur

Not available with this kind of connection

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.

Example

See additional examples

// 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.
hErrMain Number of the main error.
hSubErrFirst Number of the first sub-error.
hSubErrLast Number of the last sub-error.
hSubErrNext Number of the next sub-error.
hSubErrPrevious Number of the previous sub-error.

This parameter is ignored.

Remarks

HFSQL error numbers

To get the main HFSQL error numbers, see: HFSQL errors.

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