|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| When several data files are used in a query, the query editor automatically searches for the links between these files defined in the analysis... |
|
|
|
|
|
|
|
| The code history is used to... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| Usage example of the zipCurrentFile function |
|
|
|
|
|
|
|
| Writes:
a character string into an external file.
a memory section.... |
|
|
|
|
|
|
|
| To quickly modify the operating mode of an application, you can use application patches...... |
|
|
|
|
|
|
|
| The NbWorksheet property is used to get the number of worksheets in a Spreadsheet control. |
|
|
|
|
|
|
|
| The CtDescribedPassword property allows you to set the password used to open the data file in an OLE DB connection (file defined in the code only). |
|
|
|
|
|
|
|
| The ColumnWidth property is used to get and change the width of each column in a multi-column Looper control. |
|
|
|
|
|
|
|
| Modifies the type and duration of the animation used when closing the application windows. |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage an analysis...... |
|
|
|
|
|
|
|
| A Java Applet control allows you to easily include Java Applets in your WEBDEV sites...... |
|
|
|
|
|
|
|
| In the Scheduler control, the appointment is displayed in a specific area...... |
|
|
|
|
|
|
|
| Inserts a row into a Looper control. |
|
|
|
|
|
|
|
| Usage example of the FTPMakeDir function |
|
|
|
|
|
|
|
| Usage example of the FTPRenameFile function |
|
|
|
|
|
|
|
| Usage example of the iDocumentCanceled function |
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Reads a line from an external file (ANSI or UNICODE). |
|
|
|
|
|
|
|
| Usage example of the FTPRemoveDir function |
|
|
|
|
|
|
|
| Draws a polygon in an Image variable. |
|
|
|
|
|
|
|
| Draws a polygon in an Image control, |
|
|
|
|
|
|
|
| Usage example of the SQLModify function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|