|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database... |
|
|
|
|
|
|
|
| The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis. |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| Two types of browse can be used to browse the result of a query run by SQLExec... |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native SAP ASE Connector... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| The description window of a select query includes several sections...... |
|
|
|
|
|
|
|
| Closes the current connection and frees the memory used by the connection. |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time...... |
|
|
|
|
|
|
|
| Positions on the previous row of the query result. |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
| Positions on the next row of the query result. |
|
|
|
|
|
|
|
| Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
|
| Sets the position on the last row of the query result. |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications... |
|
|
|
|
|
|
|
| The description window of a combining query consists of several sections...... |
|
|
|
|
|
|
|
| You have the ability to pass parameters to a procedure.... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
|
| To simplify the maintenance or the use of existing code by other developers, WINDEV proposes... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.... |
|
|
|
|
|
|
|
| A procedure is used to associate an identifier with a statement block...... |
|
|
|
|
|
|
|
| Syntax for calling a local or global procedure. |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries...... |
|
|
|
|
|
|
|
| A global procedure can be used in all the processes or events of the project.... |
|
|
|
|
|
|
|
| A color (text color) can be assigned to the procedures so that they can be easily classified... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item...... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items...... |
|
|
|
|
|
|
|
| The global procedures are grouped in set of procedures...... |
|
|
|
|
|
|
|
| Two types of procedures are available...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|