PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Use
  • Use case
  • Browsing the files
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Native MariaDB Connector: Specific features
Native AccessesAvailable 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 numberValue
......
98Tata
99Toto
100Toto
101Toto
102Tutu
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").
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment