|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database... |
|
|
|
|
|
|
|
| Native MySQL Connector License Agreement |
|
|
|
|
|
|
|
| The CtCacheSize property is used to determine and change the maximum number of records that can be stored in the cache of the Native MySQL Connector. |
|
|
|
|
|
|
|
| WordPress offers numerous templates to create original websites... |
|
|
|
|
|
|
|
| Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
|
| Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
The Source property can be used on:- Chart control field field: in this case, the Source property indicates the source of the series: table column, list of values, etc, ...
- connection in which case the Source property is used to identify or define the source of a connection (HFSQL Client/Server, OLE DB, etc.).
|
|
|
|
|
|
|
|
| The project description window allows you to configure various elements of your project... |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| To migrate a WEBDEV site to PHP... |
|
|
|
|
|
|
|
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) defined in the data model editor or with HOpenConnection.
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| Like for any application, WINDEV allows you to create a setup program for a Java application... |
|
|
|
|
|
|
|
| WINDEV allows you to generate a Java application without even knowing the Java language... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files... |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Opens a connection to a specific Client/Server database to manage User Groupware files in Client/Server mode. |
|
|
|
|
|
|
|
Returns the list of files:- current analysis.
- analyses in progress (projects with multiple analyses).
- a specific analysis recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| Stores the current context of a data file: current record, filter, read pointers. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| The CtOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections programmatically, you have the ability to specifier the optional connection information... |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
The CalculatedItemExpression property is used to:- Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or programmatically.
- Define the SQL expression returning the value of a calculated item (when describing the item through programming).
|
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
| A site generated in PHP can be debugged in standard WEBDEV mode... |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| The automatic assisted replication is used to easily implement a replication on an existing application... |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in PHP... |
|
|
|
|
|
|
|
| Creates an empty data file (extension ".FIC") with index file, full-text index file, spatial index file and memo file if required. |
|
|
|
|
|
|
|
| Creates an empty data file (file extension ".FIC") with index file, full-text index file and memo file if required. |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| This document presents the different access modes to databases from a WINDEV Java application... |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| The assisted replication through programming is used to implement a replication on an existing application while controlling the synchronization in the application itself... |
|
|
|
|
|
|
|
| A Java application is an application entirely compiled in Java... |
|
|
|
|
|
|
|
| An LDM (Logical Data Model) is used to describe data structures (data files, fields, etc.)... |
|
|
|
|
|
|
|
| WINDEV Tutorial - External database
Using data from an external database - 40 min |
|
|
|
|
|
|
|
| Java applications in practice |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose the Enumeration and Combination types... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
The Type property is used to get:- the type of element (data file or item) defined programmatically or in the data model editor, view or query.
- the type of object.
- the type of data held in a Variant.
|
|
|
|
|
|
|
|
| The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| The native access to HFSQL Classic and Client/Server is available for WINDEV applications running in Linux ("console" applications) and for the WEBDEV websites hosted in Linux... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| WINDEV allows you to create native 64-bit Linux executables. Their UI is developed with the window editor. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| WEBDEV 2026 is now available. |
|
|
|
|
|
|
|
| WINDEV 2026 is now available. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| What's new in WINDEV/WEBDEV/WINDEV Mobile 2025 in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| What's new in WINDEV/WEBDEV/WINDEV Mobile 2025 in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure. |
|
|
|
|
|
|
|
| What's new in WINDEV/WEBDEV/WINDEV Mobile 2024 in the 2024 New Features brochure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|