|
|
|
|
|
|
|
|
|
|
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.
IF HCreate(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: This information is not available for all the 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. | | hErrADOMessage | Message corresponding to the error returned by ADO (hErrADO). | | hErrBase | | | hErrBaseMessage | | | 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. | | 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. | | hErrFIC | Full name of data file associated (".FIC") with the error. | | hErrFicList | List of HFSQL files with errors. Use example: If there are password-protected data files, gets the list of data files with errors when creating a replication. This list contains the physical names of the different data files, separated by CR characters. | | 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 the one retrieved via the "Copy" button in the WLanguage error window. | | hErrItem | Name of the item associated with the error. | | hErrLink | Name of the link associated with the error. | | hErrLockInfo | | hErrMessage
(default value) | Message associated with the error | | hErrMMO | Full name of the memo file (".MMO") associated with the error | | 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. | | hErrNativeMessage | Message corresponding to the error returned by the provider of the Native Connector (hErrSystemCode) | | hErrNDX | Full name of the index file (" .NDX") associated with the error. | | hErrOLEDB | Error code returned by the system during an access via an OLE DB connection. | | hErrOLEDBMessage | Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB) | | 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> | | hErrRecNum | Number of the record associated with the error | | 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) | | hErrSystemMessage | Message of the associated system error (if any) | | hErrWDD | Full name of analysis file (.WDD file) associated with the error |
Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|