Home | Sign in | French EN
  • Overview
  • Programming
  • 1. Establishing the connection
  • 2. Running queries
  • 3. Retrieving the result
  • 4. Closing the connection
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
The SQL functions can be used to handle the MySQL database.
Differences compared to HFSQL programming: The use of SQL functions for handling the MySQL data does not require to import the structure of the files into the analysis. However, the data must be handled by queries only. The content of MySQL files cannot be read directly.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.

1. Establishing the connection

SQLConnect is used to establish a connection to a MySQL database via the Native Connector. The type of database used (MySQL in this case) must be passed in parameter to SQLConnect.
Remark: The name of the MySQL data source ("MySQLDatabase" in this case) is the name or the IP address of the computer where the database is available. In any case, the name of the "Database" must be specified.
ConnectionNum = SQLConnect("MySQLDatabase", "", "", "", "MySQL")
// or ConnectionNum = SQLConnect("MySQLDatabase", "User", "Password", "MyDatabase", "MySQL")

// Connection to a remote MySQL database
ConnectionNum = SQLConnect("", "User", "Password", "test", "MySQL")

2. Running queries

The queries are run by SQLExec. SQLExec expects in parameter the text of the SQL query as well as the name that will be given to this query.

3. Retrieving the result

Several methods can be used to retrieve the result:
  • SQLFirst: Used to retrieve the result and to initialize a SQLFirst/SQLCol browse.
  • SQLTable: Used to retrieve the result of the query in a memory table of the WINDEV application or WEBDEV site. The result of the query can be retrieved by partial Fetch.
  • SQLFetch: Used to browse the different lines of query result. The browse performed in the query result is a SQLFetch/SQLGetCol browse.
SQLLock is used to lock either the table records, or the records selected by the query. The time-out (maximum wait) to lock or modify a locked record is set to 50s by default on MySQL. When the time-out value is reached, an error is returned by the database.

4. Closing the connection

SQLClose is used to close the connection to the database when all the necessary queries have been run.
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment