|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Usage example of the SQLExec function |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The TotalNbRec property is used to:
Get the number of records to be printed.
Change the number of records to be printed.... |
|
|
|
|
|
|
|
| The FOR EACH statement is used to run different types of HFSQL loops... |
|
|
|
|
|
|
|
| Returns the number of elements in a List Box, ListView or Combo Box control. |
|
|
|
|
|
|
|
| Modifies the status of an event. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the number of the current record in a Table control based on a data file. |
|
|
|
|
|
|
|
| Usage example of the HConnect function |
|
|
|
|
|
|
|
| The Organizer control is used to display and handle organizers...... |
|
|
|
|
|
|
|
| The different types of items proposed in the data model editor are as follows: |
|
|
|
|
|
|
|
| The report editor can be used to create form reports, which include different controls allowing users to enter data...... |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The following constants are used to manage Scheduler and TimeLine controls:... |
|
|
|
|
|
|
|
| The parameters can be passed to a procedure...... |
|
|
|
|
|
|
|
| Usage example of the iInitReportQuery function |
|
|
|
|
|
|
|
| The report editor allows you to propose clickable controls during the print preview...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|