|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value. |
|
|
|
|
|
|
|
| Once the connection to the database is established, WDSQL allows you to create different types of SQL queries...... |
|
|
|
|
|
|
|
| WDSQL is used to run all the SQL queries created by WDSQL...... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file...... |
|
|
|
|
|
|
|
| The result of a select query can be...... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ...... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| WDSQL is used to convert the structure of an HFSQL database into SQL script...... |
|
|
|
|
|
|
|
| WDSQL is used to find out the structure of the accessed database...... |
|
|
|
|
|
|
|
| A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ...... |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database...... |
|
|
|
|
|
|
|
| The keyword "Query" is used to describe: |
|
|
|
|
|
|
|
| The following paragraphs present...... |
|
|
|
|
|
|
|
| A query (typed in SQL code) can operate on different databases...... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|