ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL
  • Overview
  • Error codes common to all Native Connectors
  • Error codes specific to certain Native Connectors
  • Error codes specific to MySQL Native Connector
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Management errors specific to Native Connectors
Native Connectors (Native Accesses)Available only with this kind of connection
Overview
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError. You have the ability to process the error and to retry the operation.
This page lists the main file management errors that can occur with Native Connectors.. For each error, you will find:
  • its number
  • the details of the error
You'll find error codes common to all Native Connectors, followed by error codes specific to the MySQL Native Connector.
Remark: The HErrorInfo function returns detailed information on the last error encountered when managing files via a Native Connector.
Error codes common to all Native Connectors
1: Phase shift between HFSQL engine and Native Connector
A phase shift was observed between the HFSQL engine and the Native Connector.. The number of record items supplied by the HFSQL engine is invalid.
2: Phase shift between SQL engine and Native Connector
A phase shift was observed between the SQL engine and the Native Connector. The query type specified by the SQL engine is unknown to the Native Connector..
4: Internal error on Nativeconnectors
A valid current record is required by the current operation. No current record is defined.
5: HFSQLengine error
The operation requested of the Native Connector requires a correctly initialized path.. No browse was initialized on the specified item.
6: HFSQLengine error
The specified search item is not found.
7: HFSQLengine error
A started browse is required by this operation. No browse was started on the specified data file.
8: Native Connector Error
This operation is not supported by the Native Connector.
9: Engine error HFSQL
The specified transaction is invalid.
10: Native Connector Error
Unable to validate the specified transaction: the corresponding internal transaction has not ended.
The internal transaction must be ended.
11: HFSQLengine error
The identifier of the stored position is invalid.
12: System error
Insufficient memory. The memory allocation required by the operation was refused by the system.
13: Operationfails
Operation failure. This failure may be caused by an operation of another user. The current operation requires to re-read the current record in the database. The current record was not found. It has been modified or deleted from the database.
14: HFSQLengine error
The specified connection does not exist.
15: System error
Unable to read or open the specified file.
16: Non-compatible libraries
The libraires used correspond to several incompatible versions. The HFSQL library is too old to be used by the Native Connector. Reinstall the compatible libraries.
17: WLanguageerror
WLanguage programming error relating to Native Connector capabilities. The structure of the data file does not support this operation. No suitable browse item found.
18: WLanguageerror
The operation cannot be performed: the specified record number does not match the current record number (0).
Specify 0 as record number.
19: HFSQLerror
The specified file or table is not opened.
20: Programming error
Programming error or incompatible modification of the file structure. The description of the file in the database is not compatible with the description of the file in the analysis.
Several solutions can be implemented:
  • Synchronize the analysis with the database and recompile the program.
  • Modify the structure of the file in the database.
  • Recreate the file using function HCréation (the records contained in the file are lost)..
21: Error returned by database concerning automatic identifier
Failure caused by an error returned by the database. This error message is added to the following message: Failed to automatically determine the value of the specified file's automatic identifier.
22: Error returned bydatabase
The details of this error are contained in the error message.
23: Client layer error
General client library protection error used by the Native Connector.
Possible cause: The client library is not compatible with the Native Connector (version too old or too recent in relation to the Native Connector).
24: Repositioning failure
Failure to reposition on the specified record (with HRestorePosition for instance).
To avoid this error, add an automatic identifier into the file.
26: Database error
The item specified as part of an index was not found in the list of table items.
Check the consistency between the table description and the index description in the database.
27: Installation error
The client library is not installed properly. Reinstall the client library.
29: HFSQL engine error related to transactions
Attempt to lock while no transaction is in progress. You must use SQLTransaction before SQLLock.
30: Programming error
The file is not found in the database. Use HCreation to create the file.
31: Installation error
Native Connector serial number is invalid. It is necessary to re-install the Native Connector.
32: SQLengine error
Inconsistent query correction data transmitted to the Native Connector by the SQL engine.
To execute this query as is, use the constant hRequêteSansCorrection.
This problem can also be caused by an alias of calculated item. If an alias of calculated item is named as an item of the source file, the name of the calculated item must be modified.
34: Error returned bydatabase
Error while reindexing the file on the specified key.
35: Programming error
This operation is not supported by the Native Connector on an "uncorrected" query..
Do not specify the constant hRequêteSansCorrection or use another query to perform this operation.
37: Installation error
A function required by the Native Connector has not been found in the client library. Installed client library not compatible with Native Connector.
Reinstall the client library.
38: Programming error
Syntax error: the delimiter of the specified variable was not found nearby.
You must fix the query.
39: Programming error
Syntax error: variable name not found nearby.
You must fix the query.
40: Programming error
Syntax error: the specified input/output variable is not used in the query. The variable was probably misspelled in the query or when it was declared.
You must fix the query.
41: Programming error
The requested operation requires the addition or the completion of the WHERE clause. This is impossible because the query was executed with the constant hRequêteSansCorrection.
If you can't run this query without the constant hRequêteSansCorrection, you can try restarting the query result path before this operation..
50: HFSQL engine error on SQLfunctions
The subscript of the specified column is greater than the number of columns found in the query result.
51: HFSQL engine error on SQLfunctions
The subscript of the specified column is invalid.
Error codes specific to certain Native Connectors
WINDEVWEBDEV - Server codeWindows

Error codes specific to MySQL Native Connector

100: Server configuration error
The query exceeds the maximum length authorized on the server.
Increase the maximum length authorized on the server.
101: MySQL client library error
General protection fault in MySQL client library. The client library is incompatible with the Native Connector..
Install a compatible client library (to do so, copy a compatible libmysql.dll library beside the WINDEV executable).
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/23/2024

Send a report | Local help