|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the database schema... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing 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 use of SQL functions to handle DB2 data does not require importing the table structure into the database schema... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Access Connector to MariaDB ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector to PostgreSQL... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| Declares the end of the query execution and frees the memory resources allocated... |
|
|
|
|
|
|
|
| The Null keyword can be used according to different methods in WLanguage...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQLite... |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| The "Analysis" pane lists...... |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector to SQLite. This Native Connector allows you to access... |
|
|
|
|
|
|
|
| The query editor automatically creates a technical documentation for each query...... |
|
|
|
|
|
|
|
| Positions on the specified result row of the query. |
|
|
|
|
|
|
|
| Modifies the content of a row in the query result. |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| The procedures and the methods of classes can have several syntaxes.... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable... |
|
|
|
|
|
|
|
| Checks the existence of a query. |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|