|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| When several tables are used in a query, the query editor automatically searches for the links between these tables described in the database schema... |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| Returns the list of invalid identifiers on the APN service of Apple. |
|
|
|
|
|
|
|
| The general parameters of the check must be defined when creating or modifying a check...... |
|
|
|
|
|
|
|
| Returns or modifies the system date (current date and time defined on the current computer). |
|
|
|
|
|
|
|
| Stops and resets a running stopwatch. |
|
|
|
|
|
|
|
| The FontStrikeOut property is used to:
Determine if the text displayed is struck through.
Apply strikethrough formatting (or not) the text displayed in a control.... |
|
|
|
|
|
|
|
| Inserts a row into a Looper control. |
|
|
|
|
|
|
|
| Reads a persistent value. |
|
|
|
|
|
|
|
| Performs a rotation:
of an Image control.
of an Image variable.
of a picLayer variable.... |
|
|
|
|
|
|
|
| Extracts the last characters from a string or string buffer. |
|
|
|
|
|
|
|
| Converts:
a UNICODE string to ANSI (Windows).
a buffer containing a UNICODE string to a buffer containing an ANSI string (Windows).... |
|
|
|
|
|
|
|
| Returns the number of the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| Closes the current connection and frees the memory used by the connection. |
|
|
|
|
|
|
|
| Copies the attachment of current email onto the user computer (locally). |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current analysis or in a specific analysis |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL data files. |
|
|
|
|
|
|
|
| Reads:
a block of bytes (characters) in an external file (ANSI or Unicode),
the content of an external file (ANSI or Unicode) and assigns it to a memory area.... |
|
|
|
|
|
|
|
| Allows you to find out or modify the name of the CD or DVD to burn. |
|
|
|
|
|
|
|
| Retrieves the result or the header of last HTTP request run. |
|
|
|
|
|
|
|
| Finds the Xth position of a string within another string. |
|
|
|
|
|
|
|
| Gets the description of a variable. |
|
|
|
|
|
|
|
| Writes a message intended to another socket. |
|
|
|
|
|
|
|
| The Memory property determines if the specified control is populated programmatically or is based on a table. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|