HError (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Managing the sub-errors

See also

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

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. 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

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

See additional examples

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

Remarks

HFSQL error numbers

To find out the main numbers of HFSQL errors, see: the HFSQL errors.

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 : wd260hf.dll