|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Contains the number of the physical record loaded in memory (which means the number of the last record read). |
|
|
|
|
|
|
|
| WINDEV Tutorial: WINDEV application: Managing data Lesson 4 - Simple printing - 20 min |
|
|
|
|
|
|
|
| Sets the position on the first record according to a browse item. |
|
|
|
|
|
|
|
| Signals the end of the document to print and actually starts printing the data stored in the printer spooler via the following functions: iPrint, iPrintImage, iNewLine, etc. |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| The "Project explorer" pane is used to simplify the development environment of WINDEV, WEBDEV and WINDEV Mobile...... |
|
|
|
|
|
|
|
| Opens a non-modal child window. |
|
|
|
|
|
|
|
| The Link control is used to:
create a link in an HTML page.
create a link in a report printed in HTML format.... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the SQL Server database...... |
|
|
|
|
|
|
|
| Usage example of the HExecuteQuery function |
|
|
|
|
|
|
|
| Usage example of the HExecuteSQLQuery function |
|
|
|
|
|
|
|
| Usage example of the SQLFirst function |
|
|
|
|
|
|
|
| The CacheSize property is used to:
Get the maximum number of records that can be stored in the cache of the Native MySQL Connector.
Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.... |
|
|
|
|
|
|
|
| The "Combo Box" control is used to display a list of elements and to select an element from this list...... |
|
|
|
|
|
|
|
| Opens a WINDEV window and closes all the other windows that were opened beforehand. |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm...... |
|
|
|
|
|
|
|
| Dynamically compiles an Procedure whose source code is provided (dynamic compilation). |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server tables...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|