|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Once a report was created, the description of this report can be modified at any time...... |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Refreshes a Table or TeeeView Table control from a given position:
for a control linked to a file: changes made in the linked data file are reflected in the control.
for a control handled programmatically: the calculated columns are re-calculated.... |
|
|
|
|
|
|
|
| Drag and Drop is used to transfer data between several controls with the mouse. This data can be moved between several controls found in the same application or in different applications.... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| This document presents the different access modes to databases from a WINDEV Java application...... |
|
|
|
|
|
|
|
| The BrowsedItem property is used to:
Get the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files.
Change the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files. Then, the iteration is reinitialized.... |
|
|
|
|
|
|
|
| The logical operators are as follows...... |
|
|
|
|
|
|
|
| The NbLabelCopy property is used to:
Get the number of copies of identical labels.
Change the number of copies of identical labels.... |
|
|
|
|
|
|
|
| The following events are associated to reports (order of appearance in the code editor)...... |
|
|
|
|
|
|
|
| Restores the context of a previously saved file (HSavePosition): current record, filter, pointers. |
|
|
|
|
|
|
|
| Closes a synchronization event between several threads. |
|
|
|
|
|
|
|
| The development in "3-tier" architecture is now simplified...... |
|
|
|
|
|
|
|
| The FOR EACH statement is used to run different types of HFSQL loops... |
|
|
|
|
|
|
|
| Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified. |
|
|
|
|
|
|
|
| Usage example of the SQLExec function |
|
|
|
|
|
|
|
| Returns the number of elements in a List Box, ListView or Combo Box control. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The TotalNbRec property is used to:
Get the number of records to be printed.
Change the number of records to be printed.... |
|
|
|
|
|
|
|
| Modifies the status of an event. |
|
|
|
|
|
|
|
| Usage example of the HConnect function |
|
|
|
|
|
|
|
| The report editor can be used to create form reports, which include different controls allowing users to enter data...... |
|
|
|
|
|
|
|
| Returns the number of the current record in a Table control based on a data file. |
|
|
|
|
|
|
|
| The following constants are used to manage Scheduler and TimeLine controls:... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|