|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the database schema... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the table structure into the database schema... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Access Connector to MariaDB ... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector to PostgreSQL... |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined... |
|
|
|
|
|
|
|
| Creates an HFSQL view.
This function uses the former view mechanism.... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support... |
|
|
|
|
|
|
|
| The CtCacheSize property is used to determine and change the maximum number of records that can... |
|
|
|
|
|
|
|
| ...This type of Native Connector allows access to ACCESS databases for better interoperability... |
|
|
|
|
|
|
|
| By default, WDMap displays the records found in a data file by using the following rules...... |
|
|
|
|
|
|
|
| The hScheduleMaterializedView type is used to programmatically manage a task for recalculating... |
|
|
|
|
|
|
|
| Like for any application, WINDEV allows you to create a setup program for a Java application...... |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor...... |
|
|
|
|
|
|
|
| For backward compatibility with the earlier versions of Native Oracle Connector (also called Native... |
|
|
|
|
|
|
|
| The Native MariaDB Connector creates "InnoDB" tables to support locks and transactions on a MariaDB... |
|
|
|
|
|
|
|
| This help page presents the actions that can be performed from the description window of a query.... |
|
|
|
|
|
|
|
| ODBCDatabaseName is used to:
Find out the name of the database used when printing a report... |
|
|
|
|
|
|
|
| The ODBCConnectionName property is used to:
Identify the name of the ODBC connection used... |
|
|
|
|
|
|
|
| User-friendly editors in practice... |
|
|
|
|
|
|
|
| ODBCUserName is used to:
Identify the username used to connect to a database via an ODBC driver... |
|
|
|
|
|
|
|
| The Source property can be used on:
a Chart control: in this case, the Source property is used... |
|
|
|
|
|
|
|
| The Native AS/400 Connector simplifies access to AS/400 data from your WINDEV and WEBDEV... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native Sybase... |
|
|
|
|
|
|
|
| A Data source variable is used to describe a temporary data source (query, view, alias, ...) |
|
|
|
|
|
|
|
| The ODBC driver on HFSQL Classic is used to access a HFSQL Classic database from an external... |
|
|
|
|
|
|
|
| The ODBCPassword property is used to:
Identify the password used to connect to a database via... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|