|
|
|
|
|
|
|
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| 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 defined 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... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| Returns a list of keys to add to tables to improve query performance. |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The code history is used to... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| The Cell control contains controls...... |
|
|
|
|
|
|
|
| Displays or hides a sliding window (sliding menu). |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| The X property is used to:
Get the X-coordinate of a control, Table control column or window (position on the X-axis).
Get the X-coordinate of a control or window (position on the X-axis).... |
|
|
|
|
|
|
|
| The following events are associated with Organizer controls:... |
|
|
|
|
|
|
|
| WEBDEV Tutorial - WEBDEV layouts Lesson 2 - Layouts: Managing menus - 30 min |
|
|
|
|
|
|
|
| The Multiselection property gets and sets the selection mode:
in a Table and TreeView Table control.
in a Pivot Table control.
in a List Box and ListView control.
in a Looper control.
in a Calendar control.
of files in an Upload control.... |
|
|
|
|
|
|
|
| The Value property is used to:
Find out and modify the value of a report control.
Find out and modify the value of a control or the title of a window.
Find out the identifier of a stream.
Find out and modify the value of a control or the title of a page.... |
|
|
|
|
|
|
|
| This control can be used to display dates, times and currency values while respecting the corresponding display format...... |
|
|
|
|
|
|
|
| The CtDescribedUserName property is used to set the username that will be used when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| A slider control is used to select a value between two bounds...... |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| A Dockable Panel control can be handled through programming...... |
|
|
|
|
|
|
|
| Displays a Table or TreeView Table control from a specified row or returns the index of the first row displayed in a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Development teams that have design expertise sometime want to be able to create their own skin templates...... |
|
|
|
|
|
|
|
| Configures the print destination. |
|
|
|
|
|
|
|
| The CtUserName property sets the username used to connect to a specific table via OLE DB. |
|
|
|
|
|
|
|
| Gets or sets the current drive. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|