|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the database schema... |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows... |
|
|
|
|
|
|
|
| The use of SQL functions to handle Sybase data does not require importing the file structure into the database schema... |
|
|
|
|
|
|
|
| Two types of browse can be used to browse the result of a query run by SQLExec... |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure into the database schema |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the table structure into the database schema... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| The use of SQL functions to handle SQLite data does not require importing the table structure into the database schema. |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| Main file extensions created and managed by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Applies formatting to SQL code: syntax highlighting, style standardization, etc. Note: This function is only available from version 2026 - Update 1. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Remarks and specific features of Native PostgreSQL Connector... |
|
|
|
|
|
|
|
| Applies formatting to SQL code: syntax highlighting, style standardization, etc. Note: This function is only available from version 2026 - Update 1. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| Returns a CSS style sheet corresponding to a WLanguage code theme. Note: This function is only available from version 2026 - Update 1. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Access Connector to MariaDB ... |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SAP ASE Connector (also called Native Sybase Access)... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native SAP ASE Connector... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector to PostgreSQL... |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters... |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis... |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file...... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|