|hErrADO||Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.|
Error code returned by the database. The corresponding message is returned by the hErrBaseMessage
Versions 26 and laterhErrCode New in version 26hErrCodehErrCode |Number of the last error triggered by the HFSQL engine.|
|hErrSystemCode||Number of the associated system error (if it exists)|
|hErrFullDetails||Full error details (error line, current process, etc.).|
Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage.
|hErrFIC||Full name of data file associated (".FIC") with the error. |
|hErrFile||Logical name of data file associated with the error|
During a lock error (HErrorLock
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 +
<Login of user who locked the database> + TAB +
<Computer from which the database was locked>
|hErrClientInfo||Information about the client layer used by the Native Access that returned the error.|
|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.
|hErrServerInfo||Information about the server used by the Native Access that returned the error.|
|hErrLink||Name of link associated with the error. |
Versions 25 and laterhErrFicList New in version 25hErrFicListhErrFicList |List of HFSQL files in error. |
Use example: When creating a replication, if data files have a password, allows you to obtain the list of data files in error. This list contains the physical names of the different data files separated by carriage returns (CR).
|Message associated with the error|
|hErrADOMessage||Message corresponding to the error returned by ADO (hErrADO). |
Message corresponding to the error returned by the database (hErrBase
|hErrNativeMessage||Message corresponding to the error returned by the provider of the native access (hErrSystemCode)|
|hErrOLEDBMessage||Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)|
|hErrSystemMessage||Message of the associated system error (if any)|
|hErrMMO||Full name of the memo file (".MMO") associated with the error|
|hErrNative||Error code returned by the DLL used for the native access. See the documentation supplied with the native access for more details. |
The corresponding message is returned by the hErrNativeMessage constant.
|hErrNDX||Full name of the index file (" .NDX") associated with the error.|
|hErrRecNum||Number of the record associated with the error|
|hErrOLEDB||Error code returned by the system during an access via an OLE DB connection.|
Versions 20 and laterhErrPositionSQLError New in version 20hErrPositionSQLErrorhErrPositionSQLError |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>
|hErrItem||Name of the item associated with the error. |
|hErrServer||Name of the HFSQL Client/Server server that triggers the error.|
|hErrWDD||Full name of analysis file (.WDD file) associated with the error|