|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| You can use a report based on a TreeView Table control to directly print the information displayed in a TreeView Table control found...... |
|
|
|
|
|
|
|
| Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified. |
|
|
|
|
|
|
|
| This chapter presents the configuration required to install WINDEV, WEBDEV or WINDEV Mobile in 64-bit mode...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to manage the different HFSQL databases (Network, Mobile, Client/Server) of an organization...... |
|
|
|
|
|
|
|
| The Image property gets and sets the background image of a control or block. |
|
|
|
|
|
|
|
| The Sidebar control gives access to different options...... |
|
|
|
|
|
|
|
| A Static control is a control used to display a static text...... |
|
|
|
|
|
|
|
| Deletes all the internal windows from the list of internal windows browsed by an Internal Window control. |
|
|
|
|
|
|
|
| The State property gets and sets the state of an element. |
|
|
|
|
|
|
|
| WINDEV Tutorial: External components Reusing code with external components - 40 min |
|
|
|
|
|
|
|
| A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view...... |
|
|
|
|
|
|
|
| The ExtendedInfo property is used to get additional information:
about a data file accessed by a Native Connector or HFSQL Client/Server.
about an item accessed by a Native Connector or HFSQL Client/Server.
about a connection. In this case, this property is equivalent to CtExtendedInfo.... |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Modifies the title of the current window (returned by CurrentWin) and the title bar. |
|
|
|
|
|
|
|
| Discover the main characteristics of the controls... |
|
|
|
|
|
|
|
| The PhysicalName property is used to manage the physical name of HFSQL data files. |
|
|
|
|
|
|
|
| The DescribedPhysicalName property is used to manage the physical name of HFSQL data files. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|