|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information...... |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector...... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Progress Connector...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector...... |
|
|
|
|
|
|
|
| The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile, Client/Server) found in the company...... |
|
|
|
|
|
|
|
| The Native Sybase Connector (also called Native Sybase Access) is used to:
specify the input values during the call to a stored procedure.
retrieve the output values after a call to a stored procedure.... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native Sybase Connector (also called Native Sybase Access)...... |
|
|
|
|
|
|
|
| The MDL file is the file used to generate a RAD window...... |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| Returns the number of the current record in a Looper control based on a data file. |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.... |
|
|
|
|
|
|
|
| Usage example of the HCloseConenction function |
|
|
|
|
|
|
|
| Usage example of the HChangeConnection function |
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Contains the number of the physical record loaded in memory (which means the number of the last record read). |
|
|
|
|
|
|
|
| WINDEV Tutorial - External database Using data from an external database - 40 min |
|
|
|
|
|
|
|
| Usage example of the HDescribeConnection function |
|
|
|
|
|
|
|
| Usage example of the HExecuteQuery function |
|
|
|
|
|
|
|
| Usage example of the SQLFirst function |
|
|
|
|
|
|
|
| Remarks and specific features of the Native Oracle Connector... |
|
|
|
|
|
|
|
| For backward compatibility with the earlier versions of Native Oracle Connector (also called Native Oracle Access), the connection can still be configured in WDORAINS (supplied with Native Oracle Connector)...... |
|
|
|
|
|
|
|
| Usage example of the XMLExecuteXPath function |
|
|
|
|
|
|
|
| Usage example of the HExecuteSQLQuery function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|