|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code...... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the SQL Server database...... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| WDSQL is used to run all the SQL queries created by WDSQL...... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use...... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming.
Define the SQL expression returning the value of a calculated item (when describing the item through programming).... |
|
|
|
|
|
|
|
| The CalculatedDefaultValue property is used to:
Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming.
Define the SQL expression that returns the default value of an item (item described through programming only).... |
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code...... |
|
|
|
|
|
|
|
| WINDEV allows you to create help window templates...... |
|
|
|
|
|
|
|
| The color constants are mainly used in the chart functions, the print functions and the drawing functions...... |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a SQL view or on a materialized view. |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|