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...... 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...... 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. 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.... 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.... Debugging in PHP A site generated in PHP can be debugged in standard WEBDEV mode...... 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...... <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. Native MySQL Connector - License Agreement Native Access Connector This type of Native Connector allows access to ACCESS databases for better interoperability purposes...... Native Progress Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose an optional Native Connector to Progress ...... Native SQL Server Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server 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...... 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.... Native Oracle Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... Optional connection information When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information...... 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)...... 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 PostgreSQL Connector for WINDEV and WEBDEV WINDEV and WEBDEV propose a Native Connector to PostgreSQL...... 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, ......