PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Use
  • Use case
  • Browsing 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 MySQL Access: Specific features
Native AccessesAvailable only with this kind of connection
Overview
The 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 access: 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 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 9
This page is also available for…
Comments
Click [Add] to post a comment