Native MariaDB Connector: Specific features

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native MariaDB Connector

Native MariaDB Connector: Specific features

Overview

Use

See also

Native MariaDB Connector for WINDEV and WEBDEV

Native MariaDB Connector: Specific features

Available only with this kind of connection

Overview

The Native MariaDB Connector creates "innoDB" tables to allow the management of locks and transactions on a MariaDB database.

See the documentation about MariaDB to find out specific features of this type of table.

Use

Use case

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

Native MariaDB Connector: SQLLock and SQLTransaction are used to manage the locks and transactions on the MariaDB "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 MariaDB. 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 the files

When a browse is performed on a MariaDB 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 MariaDB 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").