|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Deletes an internal window found in the list of internal windows browsed by an Internal Window control. |
|
|
|
|
|
|
|
| The NbThumbnail property is used to get the number of thumbnails generated for an item. |
|
|
|
|
|
|
|
| The OAuth2Parameters type is used to define the information required to authenticate on a web service implementing the OAuth 2.0 standard. |
|
|
|
|
|
|
|
| The Unalterable property is used to configure the unalterability of a data file: the data file cannot be modified; only additions can be made. |
|
|
|
|
|
|
|
| NbRecRead is used to find out the number of records read: selected both by the source of the report AND by the filter code (if it exists). |
|
|
|
|
|
|
|
| Variables are copied using the "=" operator... |
|
|
|
|
|
|
|
| The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo). |
|
|
|
|
|
|
|
| The MaxThumbnailHeight property is used to get and change the maximum height of a thumbnail of an Image item (binary memo). |
|
|
|
|
|
|
|
| Usage example of the HTTPRequest function |
|
|
|
|
|
|
|
| Usage example of the ChangeCharset function |
|
|
|
|
|
|
|
| WinSize:
returns or modifies the window display mode (maximized, minimized or normal),
modifies the window height and/or width,
moves the window and modifies a window's height and/or width.... |
|
|
|
|
|
|
|
| A Table control proposes an automatic popup menu allowing the user to perform several operations on the data displayed in the table...... |
|
|
|
|
|
|
|
| Usage example of the FTPConnect function |
|
|
|
|
|
|
|
| Usage example of the fMakeDir function |
|
|
|
|
|
|
|
| Usage example of the XMLParent function |
|
|
|
|
|
|
|
| Usage example of the fDate function |
|
|
|
|
|
|
|
| The report editor gives you the ability to create "Organizer" reports.... |
|
|
|
|
|
|
|
| The NbPrintedRec property is used to determine the number of records already printed. |
|
|
|
|
|
|
|
| The InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully. |
|
|
|
|
|
|
|
| Usage example of the fDateTime function |
|
|
|
|
|
|
|
| Usage example of the fCopyDir function |
|
|
|
|
|
|
|
| Configures the print destination. |
|
|
|
|
|
|
|
| Starts the execution of a process through programming. |
|
|
|
|
|
|
|
| Gets or sets the current drive. |
|
|
|
|
|
|
|
| The report editor allows you to create "Scheduler" reports.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|