PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns a detailed information about the last error triggered by the HFSQL engine.
Notes:
  • 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.
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
// Manage an error wile creating a file
IF HCreation(Customer) = False THEN
Error("HFSQL error: " + 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.
Note: 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.
AndroidAndroid Widget Windows MobileUniversal Windows 10 AppPHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrBase
PHPNative Accesses Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant
hErrSystemCodeNumber of the associated system error (if it exists)
AndroidAndroid Widget PHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrFullDetailsFull error details (error line, current process, ...).
Note: 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.
AndroidAndroid Widget PHP This constant is not available.
Java Access by JDBC: This constant is not available.
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:
<Name of locked database> + TAB +
<Login of user who locked the database> + TAB +
<Computer from which the database was locked>
AndroidAndroid Widget PHP This constant is not available.
Java Access by JDBC: This constant is not available.
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.
Java Access by JDBC: This constant is not available.
AndroidAndroid Widget This constant is not available.
hErrServerInfoInformation about the server used by the Native Access that returned the error.
Universal Windows 10 App This constant is not available.
hErrLinkName of link associated with the error.
PHP This constant is not available.
hErrMessage
(default value)
Message associated with the error
hErrADOMessageMessage corresponding to the error returned by ADO (hErrADO).
AndroidAndroid Widget Windows MobileUniversal Windows 10 App This constant is not available.
Java Access by JDBC: This constant is not available.
hErrBaseMessage
PHPNative 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)
Java Access by JDBC: This constant is not available.
AndroidAndroid Widget Universal Windows 10 App This constant is not available.
hErrOLEDBMessageMessage corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)
AndroidAndroid Widget Windows MobilePHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrSystemMessageMessage of the associated system error (if any)
AndroidAndroid Widget PHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrMMOFull name of the memo file (".MMO") associated with the error
AndroidAndroid Widget PHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrNativeError 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.
AndroidAndroid Widget Universal Windows 10 AppPHP This constant is not available.
Java Access by JDBC: This constant is not available.
hErrNDXFull name of the index file (" .NDX") associated with the error.
Java Access by JDBC: This constant is not available.
AndroidAndroid Widget This constant is not available.
hErrRecNumNumber of the record associated with the error
Java Access by JDBC: This constant is not available.
AndroidAndroid Widget This constant is not available.
hErrOLEDBError code returned by the system during an access via an OLE DB connection.
AndroidAndroid Widget Windows MobileUniversal Windows 10 App This constant is not available.
Java Access by JDBC: This constant is not available.
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:
<Start row of the error> + TAB + ...
<Start column of the error> + TAB + ...
<End row of the error> + TAB + ...
<End column of the error>
AndroidAndroid Widget This constant is not available.
hErrItemName of item associated with the error.
Java Access by JDBC: This constant is not available.
AndroidAndroid Widget This constant is not available.
hErrServerName of the HFSQL Client/Server server that triggers the error.
Universal Windows 10 App This constant is not available.
hErrWDDFull name of analysis file (.WDD file) associated with the error
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment