|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The different types of items proposed in the data model editor are as follows: |
|
|
|
|
|
|
|
| The parameters can be passed to a procedure...... |
|
|
|
|
|
|
|
| ReplicEdit is a tool used to define the characteristics of a replication...... |
|
|
|
|
|
|
|
| The following constants are used to manage Scheduler and TimeLine controls:... |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Usage example of the iInitReportQuery function |
|
|
|
|
|
|
|
| The report editor allows you to propose clickable controls during the print preview...... |
|
|
|
|
|
|
|
| A List Box or Combo Box control can be used to display the content of a data file, to allow a user to select a record, for example...... |
|
|
|
|
|
|
|
| Reinitializes the content of a Scheduler control from its data source (HFSQL file for example). |
|
|
|
|
|
|
|
| Reinitializes the content of a TimeLine control from its data source (HFSQL data file for example). |
|
|
|
|
|
|
|
| Reinitializes the content of an Organization Chart control from its data source (HFSQL data file for example). |
|
|
|
|
|
|
|
| This type of Native Connector allows access to ACCESS databases for better interoperability purposes...... |
|
|
|
|
|
|
|
| WINDEV proposes a help menu adapted to your applications...... |
|
|
|
|
|
|
|
| Several operations are performed when printing a report. These operations are performed in the following order...... |
|
|
|
|
|
|
|
| The sfExecuteQueryResult type is used to find out the result of SFForwardQuery and SFExecuteQuery... |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError...... |
|
|
|
|
|
|
|
| Reinitializes the content of an Organizer control from its data source (HFSQL data file for example). |
|
|
|
|
|
|
|
| The hScheduleMaterializedView type is used to programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server. |
|
|
|
|
|
|
|
| Like for any application, WINDEV allows you to create a setup program for a Java application...... |
|
|
|
|
|
|
|
| The Count property returns the number of elements in a given set. |
|
|
|
|
|
|
|
| The report editor allows you to create "Crosstab" reports...... |
|
|
|
|
|
|
|
| When creating an external component, you have he ability to define the elements of the external component that will be accessible (or not) by the user of the component...... |
|
|
|
|
|
|
|
| The mobile devices propose several features available via finger movements...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|