Native MySQL Connector: Specific features

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native MySQL Connector

Native MySQL Connector: Specific features

Overview

Use

See also

Native MySQL Connector for WINDEV and WEBDEV

Native MySQL Connector: Specific features

Available only with this kind of connection

Overview

The Native MySQL Connector (also called "Native MySQL Access") creates "innoDB" tables to allow the management of locks and transactions on a MySQL database.

See the documentation about MySQL for more details.

Use

Use case

If your server is not configured to allow the management of the "innoDB" tables, MySQL automatically creates an ISAM table (default type of the tables on MySQL). In the documentation about MySQL, you will find the details about the "configuration of the server to allow the management of the "innoDB" tables".

Native MySQL Connector: SQLLock and SQLTransaction are used to manage the locks and transactions on the MySQL "innoDB" tables.

If you want to specify another type of table (other than "innoDB"):

run an SQL query for table creation ("CREATE TABLE" command)
use the management tool of MySQL. In this case, do not use HCreation in your program. HCreation deletes the table ("DROP TABLE" command) if it already exists in order to re-create it.

Browsing files

When a browse is performed on a MySQL table, the records are not retrieved all at once but by blocks of 100 records. This value corresponds to a read "cache". This feature is used to optimize the browse operations with HReadFirst/HReadNext as well as HReadSeekXXX functions.

Note: The items identical to the last record read (which means with identical values for all the items) will not be selected by the query used to fill the "cache" for reading the next records.

Example: The following records are found in the MySQL table named "MyTable":


Record number	Value
...	...
98	Tata
99	Toto
100	Toto
101	Toto
102	Tutu

The browse code is as follows:

FOR EACH MyTable
Trace(MyTable.Value)
END

The trace window will display the following values:

Tata
Toto
Toto
Tutu

One record is missing (Record #101 whose value is equal to "Toto").