Native MySQL Connector: Specific features The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database...... Native MySQL Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose a Native Connector for MySQL...... Management errors specific to Native Connectors When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError...... HConnect (Function) Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. LINUX: Accessing the ODBC databases The native access to HFSQL Classic and Client/Server is available for the WINDEV applications running in Linux ("console" applications) and for the WEBDEV sites hosted in Linux...... Native MySQL Connector: Programming with HFSQL functions To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV analysis...... SQLLock (Function) Used to lock: The entire data table, in read and write mode. Its data cannot be accessed by other computers. The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... Debugging in PHP A site generated in PHP can be debugged in standard WEBDEV mode...... SQLTransaction (Function) Begins, commits or rolls back a transaction: on the files of a database opened by SQLConnect, on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.... Native MySQL Connector - License Agreement <Connection variable>.TransactionStart (Function) Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. <Connection variable>.Transaction (Function) Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. Handling a database from a Java application You can start developing your application as soon as the WINDEV project is defined as being a Java project...... Native Progress Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose an optional Native Connector to Progress ...... Native Access Connector This type of Native Connector allows access to ACCESS databases for better interoperability purposes...... Native SQL Server Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)...... Native Oracle Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... User Groupware and files accessed via a Native Connector An application that works with the User Groupware can be used with a database handled by a Native Connector...... Natif DB2 Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose an optional Native Connector to DB2...... Native MariaDB Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose a Native Connector to MariaDB (also called Native Access)...... Native PostgreSQL Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose a Native Connector to PostgreSQL...... ExtendedInfo (Property) The ExtendedInfo property is used to get additional information: about a data file accessed by a Native Connector or HFSQL Client/Server. about an item accessed by a Native Connector or HFSQL Client/Server. about a connection. In this case, this property is equivalent to CtExtendedInfo.... CacheSize (Property) The CacheSize property is used to: Get the maximum number of records that can be stored in the cache of the Native MySQL Connector. Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.... Native xBase/FoxPro Connector WINDEV and WEBDEV propose a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module...... Report based on a data file A report based on a data file is used to print the records coming from a single data file (HFSQL Classic or Client/Server, accessed via a Native Access, ......