|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The MinimumLength property is used to configure the minimum length of the words to be indexed. |
|
|
|
|
|
|
|
| Usage example of the INIRead function |
|
|
|
|
|
|
|
| Usage example of the FTPCurrentDir function |
|
|
|
|
|
|
|
| Usage example of the fCompare function |
|
|
|
|
|
|
|
| Usage example of the OutlookStartSession function |
|
|
|
|
|
|
|
| Writes a line into a text file (ANSI or UNICODE). |
|
|
|
|
|
|
|
| Resets to zero (for a numeric control) or clears (for the other types of controls) the content of the controls found in the current window. |
|
|
|
|
|
|
|
| The Items property is used to configure the different items of a full-text index. |
|
|
|
|
|
|
|
| Saves an information in a "log" file during the execution of an action plan. |
|
|
|
|
|
|
|
| Saves the configuration of dynamic panes found in a Tab control in character string format. |
|
|
|
|
|
|
|
| The ActiveDirectory property allows you to connect to an HFSQL server using Active Directory authentication. |
|
|
|
|
|
|
|
| Refreshes a frameset displayed in the user's browser from the context on the server.... |
|
|
|
|
|
|
|
| Sends an email using the Outlook protocol. |
|
|
|
|
|
|
|
| Saves an image:
in a file in GIF format.
in memory.... |
|
|
|
|
|
|
|
| Usage example of the MemSeek function |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| The database can be accessed via a web service...... |
|
|
|
|
|
|
|
| Rotates an Image control. |
|
|
|
|
|
|
|
| Usage example of the fStopCompress function |
|
|
|
|
|
|
|
| Usage example of the fSize function |
|
|
|
|
|
|
|
| Usage example of the fLongName function |
|
|
|
|
|
|
|
| The FontUnderlined property is used to:
Determine if the text is underlined.
Underline (or not) a text.... |
|
|
|
|
|
|
|
| The Note property is used to:
Find out the notes associated with a control, a window, a page or a report.
Modify the notes associated with a control, a window a page or a report.... |
|
|
|
|
|
|
|
| Returns the resolution of a specific element. |
|
|
|
|
|
|
|
| Usage example of the fRename function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|