|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Returns a list of keys to add to tables to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor.... |
|
|
|
|
|
|
|
| Sets the position on the last row of the query result. |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model database schema...... |
|
|
|
|
|
|
|
| To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server tables...... |
|
|
|
|
|
|
|
| A Table, List Box or Combo Box control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor.
You also have the ability to include this report in your sites. The Web user will have the ability to print the report from a button, a menu option, ... for example.... |
|
|
|
|
|
|
|
| By default, WDMap displays the records found in a data file by using the following rules...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Classic data files...... |
|
|
|
|
|
|
|
| A Table control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... |
|
|
|
|
|
|
|
| A site generated in PHP can be debugged in standard WEBDEV mode...... |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Below are the main SQL functions that can be used to handle spatial data in SQL queries...... |
|
|
|
|
|
|
|
| To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV database schema...... |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
| To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV database schema...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|