PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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. Indeed, the call to a function (other than an error function) can reinitialize and modify the status report returned by HErrorInfo.
  • ErrorInfo is equivalent to HErrorInfo.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Gestion d'une erreur lors de la création d'un fichier
IF HCréation(Client) = False THEN
Error("Erreur HFSQL: " + HErrorInfo())
END
Syntax
<Result> = HErrorInfo([<Type of information>])
<Result>: Character string
  • Caption of requested information,
  • Empty string ("") if no error occurred.
<Type of information>: Optional integer constant.
Allows you to specify 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.
hErrADOError code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.
hErrBase
Native Connectors (Native Accesses) Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant
Versions 26 and later
hErrCode
New in version 26
hErrCode
hErrCode
Number of the last error triggered by the HFSQL engine.
hErrSystemCodeNumber of the associated system error (if it exists)
hErrFullDetailsFull 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.
hErrFICFull name of data file associated (".FIC") with the error.
hErrFileLogical name of data file associated with the error
hErrLockInfo
HFSQL Client/Server 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:
<Nom de la base de données bloquée> + TAB +
<Login de l'utilisateur qui a bloqué la base> + TAB +
<Machine à partir de laquelle la base a été bloquée>
hErrClientInfoInformation about the client layer used by the Native Access that returned the error.
hErrDebugInfoSpecific 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.
hErrServerInfoInformation about the server used by the Native Access that returned the error.
hErrLinkName of link associated with the error.
Versions 25 and later
hErrFicList
New in version 25
hErrFicList
hErrFicList
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).
hErrMessage
(default value)
Message associated with the error
hErrADOMessageMessage corresponding to the error returned by ADO (hErrADO).
hErrBaseMessage
Native Connectors (Native Accesses) Message corresponding to the error returned by the database (hErrBase)
hErrNativeMessageMessage corresponding to the error returned by the provider of the native access (hErrSystemCode)
hErrOLEDBMessageMessage corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)
hErrSystemMessageMessage of the associated system error (if any)
hErrMMOFull name of the memo file (".MMO") associated with the error
hErrNativeError code returned by the DLL used for the native access. For more details, see the documentation supplied with the native access.
The corresponding message is returned by the hErrNativeMessage constant.
hErrNDXFull name of the index file (" .NDX") associated with the error.
hErrRecNumNumber of the record associated with the error
hErrOLEDBError code returned by the system during an access via an OLE DB connection.
Versions 20 and later
hErrPositionSQLError
New in version 20
hErrPositionSQLError
hErrPositionSQLError
Position of the SQL error in the SQL code of the query run by HExecuteSQLQuery.
This position is given in the following format:
<Ligne du début de l'erreur> + TAB + ...
<Colonne du début de l'erreur> + TAB + ...
<Ligne de la fin de l'erreur> + TAB + ...
<Colonne de la fin de l'erreur>
hErrItemName of the item associated with the error.
hErrServerName of the HFSQL Client/Server server that triggers the error.
hErrWDDFull name of analysis file (.WDD file) associated with the error
Business / UI classification: Business Logic
Component: wd270hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment