ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Report based on an SQL query with data accessed via a connection (ODBC, etc.)
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...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Handling a report (in the editor)
Once a report was created, the description of this report can be modified at any time......
HTransactionSavepoint (Function)
Declares a transaction savepoint.
List of reserved words
TableDisplay (Function)
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
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....
HDescribeFile (Function)
Describes a data file programmatically.
Managing databases in the WINDEV Java applications
This document presents the different access modes to databases from a WINDEV Java application......
BrowsedItem (Property)
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....
Logical operators
The logical operators are as follows......
HReconnect (Function)
Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified.
NbLabelCopy (Property)
The NbLabelCopy property is used to: Get the number of copies of identical labels. Change the number of copies of identical labels....
Events associated with reports
The following events are associated to reports (order of appearance in the code editor)......
HRestorePosition (Function)
Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
EventClose (Function)
Closes a synchronization event between several threads.
3-tier architecture
The development in "3-tier" architecture is now simplified......
FOR EACH/FOR ALL statement (loop through files)
The FOR EACH statement is used to run different types of HFSQL loops...
EventChange (Function)
Modifies the status of an event.
ListCount (Function)
Returns the number of elements in a List Box, ListView or Combo Box control.
HExecuteView (Function)
Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism.
TotalNbRec (Property)
The TotalNbRec property is used to: Get the number of records to be printed. Change the number of records to be printed....
SQLExec (Example)
Usage example of the SQLExec function
HConnect (Example)
Usage example of the HConnect function
Editable reports
The report editor can be used to create form reports, which include different controls allowing users to enter data......
TableRecNum (Function)
Returns the number of the current record in a Table control based on a data file.
Constants for managing Scheduler and TimeLine controls
The following constants are used to manage Scheduler and TimeLine controls:...