|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ... |
|
|
|
|
|
|
|
| The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database... |
|
|
|
|
|
|
|
| The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database... |
|
|
|
|
|
|
|
| Two types of browse can be used to browse the result of a query run by SQLExec... |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native SAP ASE Connector... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server... |
|
|
|
|
|
|
|
| Native SQL Server Connector (also known as Native SQL Server Access) license agreement... |
|
|
|
|
|
|
|
| SQL allows performing set operations on groups of files...... |
|
|
|
|
|
|
|
| The result of a select query can be...... |
|
|
|
|
|
|
|
| This help page presents the method for creating an SQL query used to get the first 10 records...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server... |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must... |
|
|
|
|
|
|
|
| The Native SQL Server Connector is used to:
specify the input values during the call... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one... |
|
|
|
|
|
|
|
| WDSQL is used to convert the structure of an HFSQL database into SQL script...... |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| ODBCSQLCode is used to:
Find out the SQL code of the "query performed on a connection" (data... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|