|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| The description window of a select query includes several sections...... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery). |
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming.... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code...... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & Queries. |
|
|
|
|
|
|
|
| The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...... |
|
|
|
|
|
|
|
| Regardless of the query type (Select, Insert, Delete, Update) and regardless of its creation mode (with the wizard or by SQL directly), you have the ability to use parameters. The name of the parameter is specified when creating the query.... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| List of HFSQL properties... |
|
|
|
|
|
|
|
| This help page presents the method for creating an SQL query used to get the first 10 records...... |
|
|
|
|
|
|
|
| Once the connection to the database is established, WDSQL allows you to create different types of SQL queries...... |
|
|
|
|
|
|
|
| The editor of Select queries is used to limit the number of records that will be displayed in the result of the query.... |
|
|
|
|
|
|
|
| This help page explains how to create an SQL query to filter records.... |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
| This help page explains how to create a Sum query with the query editor.... |
|
|
|
|
|
|
|
| This help page explains how to create a count query with the query editor.... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items...... |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one or more parameters...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|