|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows... |
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix 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 query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the table structure into the database schema... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Access Connector to MariaDB ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector to PostgreSQL... |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| To use an Informix database with the Native Connector, import the structure of Informix tables... |
|
|
|
|
|
|
|
| To use a Sybase database with Native Connector, the structure of Sybase tables must be imported... |
|
|
|
|
|
|
|
| To use an SQLite database with Native Connector (also called Native Access), the structure... |
|
|
|
|
|
|
|
| WDConver is a tool used to convert data to an HFSQL Classic data file from...... |
|
|
|
|
|
|
|
| The keyword "Query" is used to describe: |
|
|
|
|
|
|
|
| Begins, commits or rolls back a transaction:
on the files of a database opened by SQLConnect,... |
|
|
|
|
|
|
|
| HFSQL proposes a quick search for character strings in the data...... |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo... |
|
|
|
|
|
|
|
| To use an Oracle database with the Native Connector, the structure of ORACLE tables must... |
|
|
|
|
|
|
|
| The following paragraphs present...... |
|
|
|
|
|
|
|
| To use a DB2 database with Native Connector, the structure of DB2 tables must be imported... |
|
|
|
|
|
|
|
| ... (with the wizard or by SQL directly), you have the ability to use parameters. The name of the parameter... |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported... |
|
|
|
|
|
|
|
| Returns the characteristics of all the columns (or items):
for a given table.
for a given... |
|
|
|
|
|
|
|
| To use a Progress database with the Native Connector, you must ...... |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL... |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed... |
|
|
|
|
|
|
|
| The analysis must be synchronized with an external database if it uses...... |
|
|
|
|
|
|
|
| To use a PostgreSQL database with Native Connector (also called Native Access), the structure... |
|
|
|
|
|
|
|
| Returns the different types of columns supported:
by the data source identified by SQLConnect... |
|
|
|
|
|
|
|
| Retrieves the content of a Text Memo column found in the query result, for the current line. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|