|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Declares the font that will be used by dText in a picLayer variable. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Adds an element to a List Box, ListView or Combo Box control populated programmatically. |
|
|
|
|
|
|
|
| Usage example of the FTPDeleteFile function |
|
|
|
|
|
|
|
| Usage example of the XMLData function |
|
|
|
|
|
|
|
| Declares the font that will be used by dText in a WDPic variable. |
|
|
|
|
|
|
|
| Returns the number of screens currently connected to the current computer. |
|
|
|
|
|
|
|
| Adds a row at the end of a Looper control. |
|
|
|
|
|
|
|
| Usage example of the zipClose function |
|
|
|
|
|
|
|
| Usage example of the fTempFile function |
|
|
|
|
|
|
|
| Usage example of the FTPRenameFile function |
|
|
|
|
|
|
|
| Writes:
a character string into an external file.
a memory section.... |
|
|
|
|
|
|
|
| Inserts a row into a Looper control. |
|
|
|
|
|
|
|
| Usage example of the FTPMakeDir function |
|
|
|
|
|
|
|
| Usage example of the zipCurrentFile function |
|
|
|
|
|
|
|
| Usage example of the iDocumentCanceled function |
|
|
|
|
|
|
|
| Creates and fills a text file with the content of a text control or text variable (string variable, edit control in a window, Static control in a report, ...). |
|
|
|
|
|
|
|
| Deletes the current contact:
from a Lotus Notes or Outlook address book.
from the list of contacts on the phone (Android, iPhone or iPad, Universal Windows).... |
|
|
|
|
|
|
|
| Usage example of the EnumControl function |
|
|
|
|
|
|
|
| Usage example of the fExtractPath function |
|
|
|
|
|
|
|
| The AnchorRateRight property is used to:
Find out the anchor rate when a control moves on the horizontal axis.
Modify the anchor rate when a control moves on the horizontal axis.... |
|
|
|
|
|
|
|
| The AnchorRateHeight property is used to:
Find out the vertical anchor rate of a control.
Modify the vertical anchor rate of a control.... |
|
|
|
|
|
|
|
| Returns the horizontal position (X) of the mouse cursor relative to the specified window or control. Used in a mouse or stylus process (click, hover, left or right button down, etc.). |
|
|
|
|
|
|
|
| Returns the vertical position (Y) of the mouse cursor relative to the specified window or control. Used in a mouse or stylus process (click, hover, left or right button down, etc.). |
|
|
|
|
|
|
|
| Reads the first incoming email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|