|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The following mechanism allows developers to write WLanguage code more easily in the code editor ...... |
|
|
|
|
|
|
|
| Starts an HTTP request on a server. |
|
|
|
|
|
|
|
| Opens a synchronization event between several threads. |
|
|
|
|
|
|
|
| Implementing input suggestions in an Edit control is very simple...... |
|
|
|
|
|
|
|
| The MaxValue property is used to:
get and set the top value of a report based on a data file.
get the maximum value of the current filter.
get the maximum value of a data series in a chart.
get and set the maximum value for some types of controls.... |
|
|
|
|
|
|
|
| The "Internal report" controls are used to print several reports (secondary reports) in a single report (main report) without programming...... |
|
|
|
|
|
|
|
| The MinValue property is used to:
get and set the bottom value of a report based on a data file.
get the minimum value of the current filter.
get the minimum value of a data series in a chart.
get and set the minimum value for some types of controls.... |
|
|
|
|
|
|
|
| The DisplayedItemImage property is used to:
Get the item that corresponds to the image displayed in a ListView control.
Change the item that corresponds to the image displayed in a ListView control.... |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user. |
|
|
|
|
|
|
|
| The StoredItem property is used to:
Find out the stored item or the stored variable of a Table, Looper, List Box or Combo Box control.
Modify the stored item or the stored variable of a Table, Looper, List Box or Combo Box control.... |
|
|
|
|
|
|
|
| The BrowsedFile property gets and sets the data source used to display records in controls based on a data file. |
|
|
|
|
|
|
|
| The ODBC driver on HFSQL Classic is used to access a HFSQL Classic database from an external database software that supports ODBC accesses...... |
|
|
|
|
|
|
|
| WDReplic is a tool used to manage the replication of data between several computers that use the same application...... |
|
|
|
|
|
|
|
| The RETURN statement is used to exit the current event, process or procedure and return a result... |
|
|
|
|
|
|
|
| Adds a report into a sequence of report prints. |
|
|
|
|
|
|
|
| To transform a page in Session mode into an Active WEBDEV Page:... |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Sends a Windows message to a control or to a window. |
|
|
|
|
|
|
|
| An Item Description variable is used to describe one or more items in a data file programmatically. |
|
|
|
|
|
|
|
| The FilteredItem property is used to identify the item that has a filter implemented by HFilter. |
|
|
|
|
|
|
|
| The Name property is used to get:
the name of the font associated with a Font variable.
the name of a control, report or report block.
the name of a control, group of controls or window.
the name of a control, group of controls or page.... |
|
|
|
|
|
|
|
| All developers appreciate the possibility to debug an application directly on the device...... |
|
|
|
|
|
|
|
| Ends the process to populate a Looper control programmatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|