|
|
|
|
|
|
|
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file...... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database...... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database...... |
|
|
|
|
|
|
|
| The modified lines of code are immediately visible...... |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| SQL allows performing set operations on groups of files...... |
|
|
|
|
|
|
|
| List of SQL functions: Special case... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector...... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword...... |
|
|
|
|
|
|
|
| The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). |
|
|
|
|
|
|
|
| This help page explains how to create an SQL query to filter records.... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| For compatibility with the earlier versions of the Native SQL Server Connector (also called Native SQL Server Access), the connection can still be configured in WDSQSINS (supplied with the Native SQL Server Connector)...... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| A query (typed in SQL code) can operate on different databases...... |
|
|
|
|
|
|
|
| Native SQL Server Connector (also known as Native SQL Server Access) license agreement... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file...... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|