|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server. |
|
|
|
|
|
|
|
| Starts the execution of a process through programming. |
|
|
|
|
|
|
|
| Gets or sets the current drive. |
|
|
|
|
|
|
|
| List of events associated with the TreeView Table controls... |
|
|
|
|
|
|
|
| Enables the dynamic audit through programming. |
|
|
|
|
|
|
|
| The CtUserName property is used to set the username that will be used when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| A Table control (populated programmatically, based on a data file or based on a variable) can include Combo Box columns...... |
|
|
|
|
|
|
|
| Usage example of the HReadSeek function |
|
|
|
|
|
|
|
| Usage example of the XMLDocument function |
|
|
|
|
|
|
|
| The supported image formats are as follows:... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Saves a persistent value in the registry or in another file specified by InitParameter. |
|
|
|
|
|
|
|
| WINDEV applications automatically include a context menu for Table controls, TreeView Table controls and their columns...... |
|
|
|
|
|
|
|
| The SortOption property gets and sets the sort options used in:
text columns in Table controls,
text columns in Treeview Table controls,
List Box and ListView controls,
Combo Box controls,
attributes of Looper controls,
images, clickable images and thumbnails with automatic sequence.... |
|
|
|
|
|
|
|
| There are several steps to install the WEBDEV Application Server on a Linux server...... |
|
|
|
|
|
|
|
| Usage example of the zipDeleteFile function |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
|
|
|
|
|
|
|
| The "Breadcrumb" control corresponds to a series of links allowing the Web user to go back into the logical tree structure of a site...... |
|
|
|
|
|
|
|
| A site generated in PHP can be debugged in standard WEBDEV mode...... |
|
|
|
|
|
|
|
| WINDEV, WINDEV Mobile and WEBDEV include several functions for handling XML code...... |
|
|
|
|
|
|
|
| Performs a "blind" transfer. |
|
|
|
|
|
|
|
| Usage example of the fTime function |
|
|
|
|
|
|
|
| Identifies the name of the MDI parent window. |
|
|
|
|
|
|
|
| The Font property is used to
Get the identifier of the font used in a control in a report, page or window.
Change the font used in a control in a report, page or window.... |
|
|
|
|
|
|
|
| The Source property can be used on:
a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ...
a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|