ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Native Connectors/Native Accesses / Native MySQL Connector
  • Overview
  • Programming
  • 1. Establishing the connection
  • 2. Running queries
  • 3. Retrieving the result
  • 4. Closing the connection
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
Overview
The SQL functions can be used to handle the MySQL database.
Differences compared to HFSQL programming: The use of SQL functions to handle MySQL data does not require importing the file structure into the analysis. However, the data must be handled by queries only. The content of MySQL files cannot be read directly.
Programming

1. Establishing the connection

SQLConnect opens a connection to a MySQL database via the Native Connector. The type of database used (MySQL in this case) must be passed as 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("192.168.1.51", "User", "Password", "test", "MySQL")

2. Running queries

The queries are run by SQLExec. SQLExec expects the text of the SQL query as parameter, as well as the name that will be given to this query.
SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, PHOTO FROM CUSTOMER", "QRY1")

3. Retrieving the result

Several methods can be used to retrieve the result:
  • SQLFirst: Retrieves and iterates over the result with SQLFirst/SQLCol.
  • SQLTable: Retrieves the result of the query in a Table control populated programmatically in the WINDEV application or WEBDEV site. The result of the query can be retrieved by partial Fetch.
  • SQLFetch: Used to read the different lines of the query result. The iteration over the query result is performed with SQLFetch/SQLGetCol.
SQLLock is used to lock the table records or the records selected by the query. The timeout to lock or modify a locked record is set to 50s by default on MySQL. The database will return an error when the timeout is reached.

4. Closing the connection

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

Last update: 08/30/2022

Send a report | Local help