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.
Report based on an Organizer control
A report based on an Organizer control is used to directly print the information displayed in the Organizer control...
Report based on a Scheduler control
A report based on a Scheduler control is used to directly print the information displayed in the Scheduler control......
iPreview (Function)
Configures the print destination.
HReadSeekLast (Function)
Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search).
HReadSeekFirst (Function)
Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search).
CalendarButton (Property)
The CalendarButton property is used to determine and specify whether a Date Edit control has a button to display a popup calendar.
BTIsVisible (Function)
Used to find out whether a Bluetooth radio is visible.
OrganizerChangeMode (Function)
Modifies the time range displayed by an Organizer control (Day/Week/Month)....
SchedulerAddAppointment (Function)
Adds a new appointment into a Scheduler control.
TimestampUTC (Property)
The TimestampUTC property is used to: Find out whether a timestamp item will use UTC time or local time. This item was defined in the data model editor or through programming. Define whether a timestamp item will use UTC time or local time (when describing the item through programming)....
PersistedCalculatedItem (Property)
The PersistedCalculatedItem property is used to: Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or through programming. Define whether the value of a calculated item is stored in the data file (when describing the item through programming)....
fRemoveDir (Function)
Deletes a directory from a disk.
Left (Function)
Extracts the left part (i.e., the first characters) from a string or buffer.
ContactReset (Function)
Reinitializes: the Contact structure. a Contact variable....
HCreateView (Example)
Usage example of the HCreateView function
HErrorPassword (Function)
After the execution of a read or write function in a data file, used to find out whether an error caused by a wrong password occurred on this data file.
hScheduling (Type of variable)
The hScheduling type is used to define and find out the characteristics of the scheduling that must be performed: for a scheduled optimization task of HFSQL Client/Server files. for a scheduled backup task of HFSQL Client/Server files. for a scheduled replication of HFSQL servers....
sRead (Function)
Reads a character string in the entry buffer of the specified serial port.
fOpen (Function)
Opens an external file (ANSI or UNICODE) in order to handle it through programming.
Starting WDOptimizer in a command line
Printing a report (iPhone/iPad, Android or Universal Windows App)
When creating a report, the test of this report can be run from the report editor......
11. Table/Looper controls
Spreadsheet report
The report editor allows you to create "Spreadsheet" reports......
Reports
A report provides a custom view of data......
ControlVisible (Function)
Makes a control (or a group of controls) visible in a window. During this operation, an animation can be performed on the controls.