|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
Applies formatting to SQL code: syntax highlighting, style standardization, etc. Versions 2026 and laterNote: This function is only available from version 2026 - Update 1.  Subscription-exclusive new featureNote: This function is only available from version 2026 - Update 1. New in version 2026Note: This function is only available from version 2026 - Update 1. Note: This function is only available from version 2026 - Update 1. |
|
|
|
|
|
|
|
Applies formatting to SQL code: syntax highlighting, style standardization, etc.Versions 2026 and laterNote: This function is only available from version 2026 - Update 1. Subscription-exclusive new featureNote: This function is only available from version 2026 - Update 1. New in version 2026Note: This function is only available from version 2026 - Update 1. Note: This function is only available from version 2026 - Update 1. |
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| The CalculatedDefaultValue property is used to:
Find out the SQL expression that defines... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| in SQL code is used to...... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a SQL view or on a materialized view. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis... |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice... |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| The SQLCode code property is used to get the SQL code of a query created with the query editor... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| For compatibility with the earlier versions of the Native SQL Server Connector (also called Native... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|