HErrorInfo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HErrorInfo (Function)

In french: HErreurInfo

Not available with this kind of connection

Returns a detailed information about the last error triggered by the HFSQL engine.

Remarks:

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 HErrorInfo.
ErrorInfo is equivalent to HErrorInfo.

Example

See additional examples

// Manage an error when creating a file
IF HCreation(Customer) = False THEN
	Error("HFSQL error: " + HErrorInfo())
END

Syntax

<Result> = HErrorInfo([<Type of information>])

<Result>: Character string

Text of the requested information,
Empty string ("") if no error occurred.

<Type of information>: Optional integer constant.

Specifies the type of information to display. If this parameter is not specified, the message associated with the error is returned.
Remark: Not all this information is available for all errors.. An information is available only if it is linked to the error. Otherwise, <Result> is an empty string.
hErrADO Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.
This constant is not available.
hErrADOMessage Message corresponding to the error returned by ADO (hErrADO).
This constant is not available.
hErrBase
Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant
hErrBaseMessage
Message corresponding to the error returned by the database (hErrBase)
hErrClientInfo Information about the client library used by the Native Connector that returned the error.
hErrCode Number of the last error raised by the HFSQL engine.
This constant is not available.
hErrDebugInfo Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT.
When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database.
This constant is not available.
hErrFIC Full name of data file associated (".FIC") with the error.
This constant is not available.
hErrFicList List of HFSQL files with errors.
Example of use: When creating a replication, if data files have a password, to obtain a list of data files in error.. This list contains the physical names of the different data files, separated by CR characters.
This constant is not available.
hErrFile Logical name of data file associated with the error
hErrFullDetails Full error details (error line, current process, etc.).
Remark: Returns the same information as when you click on the "Copy" button in the WLanguage error window.
hErrItem Name of the item associated with the error.
This constant is not available.
hErrLink Name of the link associated with the error.
hErrLockInfo
During a lock error (HErrorLock returns True or the error 70100), this constant is used to return information about the lock. This information is the same as the one returned by HInfoLock (the lock lifespan is not specified).
When the access to the database was locked by HNoDatabaseAccess (error 74011), the result has the following format:
<Name of locked database> + TAB +
<User who locked the database> + TAB +
<Computer from which the database was locked>
This constant is not available.
hErrMessage
(default value) Message associated with the error
hErrMMO Full name of the memo file (".MMO") associated with the error
This constant is not available.
hErrNative Error code returned by the DLL used for the Native Connector. For more details, see the documentation provided with the Native Connector.
The corresponding message is returned by the hErrNativeMessage constant.
This constant is not available.
hErrNativeMessage Message corresponding to the error returned by the provider of the Native Connector (hErrSystemCode)
This constant is not available.
hErrNDX Full name of the index file (" .NDX") associated with the error.
This constant is not available.
hErrOLEDB Error code returned by the system during an access via an OLE DB connection.
This constant is not available.
hErrOLEDBMessage Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)
This constant is not available.
hErrPositionSQLError Position of the SQL error in the SQL code of the query run by HExecuteSQLQuery.
This position is given in the following format:
<Start row of the error> + TAB + ...
<Start column of the error> + TAB + ...
<End row of the error> + TAB + ...
<End column of the error>
This constant is not available.
hErrRecNum Number of the record associated with the error
This constant is not available.
hErrServer Name of the HFSQL Client/Server server that triggers the error.
hErrServerInfo Information about the server used by the Native Connector that returned the error.
hErrSystemCode Number of the associated system error (if it exists)
This constant is not available.
hErrSystemMessage Message of the associated system error (if any)
This constant is not available.
hErrWDD Full name of analysis file (.WDD file) associated with the error

Business / UI classification: Business Logic

Component: wd300hf.dll