Handling data files in PHP WEBDEV allows you to create a PHP site that handles data files...... WDSQL: Converting the structure of an HFSQL database WDSQL is used to convert the structure of an HFSQL database into SQL script...... Native MySQL Connector: Programming with SQL functions The SQL functions can be used to handle the MySQL database...... 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...... WDSQL, SQL querier: Overview WDSQL is used to...... 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...... <Source>.ExecuteSQLQuery (Function) Initializes a query written in SQL language and declares this query to the HFSQL engine. HExecuteSQLQuery (Function) Initializes a query written in SQL language and declares this query to the HFSQL engine. <Connection variable>.UpdateView (Function) Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. HUpdateView (Function) Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. HCopyFile (Function) Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the data files for example). from an HFSQL server to antoher HFSQL server.... <Connection variable>.CopyFile (Function) Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the data files for example). from an HFSQL server to antoher HFSQL server.... Managing HFSQL Client/Server applications The HFSQL Control Center is used to manage the HFSQL Client/Server servers and the HFSQL Client/Server databases...... Converting an HFSQL Classic database into HFSQL Client/Server There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV and WINDEV Mobile...... HFSQL Client/Server: Configuring the data files on the server 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...... ODBC driver for HFSQL Classic and for HFSQL Client/Server (Linux) The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC...... <Source>.ChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server data file.... HChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server data file.... Report based on an HFSQL view A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view...... Managing the HFSQL servers The HFSQL Control Center allows you to fully manage HFSQL servers...... Managing HFSQL Cluster Methods for managing an HFSQL cluster and its databases.... Remote HFSQL administrator: Overview ...The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server...... HFSQL server configuration The HFSQL Control Center allows you to fully manage HFSQL servers...... HFSQL Control Center: HFSQL Cluster management The HFSQL Control Center includes all the tools needed to manage HFSQL clusters......