|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Displays an Organizer control from a specified date or returns the date of the first day (or the date of the last day) displayed in an Organizer control. |
|
|
|
|
|
|
|
| Creates a directory (and the intermediate directories if necessary). |
|
|
|
|
|
|
|
| Copies the contents of a directory and its subdirectories. |
|
|
|
|
|
|
|
| Returns:
the length of a string, i.e., the number of characters in the string (including spaces and binary zeros).
the size of a buffer, i.e., the number of bytes in the buffer.... |
|
|
|
|
|
|
|
| Returns the number of elements selected in a List Box, ListView or Combo Box control. |
|
|
|
|
|
|
|
| Deletes all the appointments from an Organizer control. |
|
|
|
|
|
|
|
| Calculates the height of printable page (in millimeters) while taking the top or bottom margins into account. |
|
|
|
|
|
|
|
| Calculates the height of the image to print (in millimeters). |
|
|
|
|
|
|
|
| Calculates the width of the image to print (in millimeters). |
|
|
|
|
|
|
|
| Calculates the width (in millimeters) of the printable page while taking the left or right margins into account. |
|
|
|
|
|
|
|
| Calculates the width (in millimeters) of the text to print, according to the specified font. |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor...... |
|
|
|
|
|
|
|
| The report editor allows you to create "Spreadsheet" reports...... |
|
|
|
|
|
|
|
| A report provides a custom view of data...... |
|
|
|
|
|
|
|
| The URI (Uniform Resource Identifier) type identifies physical or abstract resources (e.g. files or Web pages). |
|
|
|
|
|
|
|
| The Anchor property sets the anchors of a control in a window, page or report. |
|
|
|
|
|
|
|
| Reads a line from an external file (ANSI or UNICODE). |
|
|
|
|
|
|
|
| Opens a non-modal sibling window. |
|
|
|
|
|
|
|
| Declares the font that will be used by dText:
in an Image control,
in an Image variable,
in a WDPic variable (on the background layer),
in a picLayer variable.... |
|
|
|
|
|
|
|
| Reads the last incoming email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook). |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Reads an incoming according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook). |
|
|
|
|
|
|
|
| The CheckSpell property is used to enable or disable the automatic spelling checker. |
|
|
|
|
|
|
|
| A break in a Looper control is used to group the data corresponding to one or more arguments...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|