ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Importing tables into the database schema (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
xlsCurrentWorksheet (Function)
Used to find out and modify the current worksheet in an XLS file.
ArrayMoveLine (Function)
Allows: move a row in a two-dimensional array or in an advanced array property. The other array rows are moved accordingly. swap two rows in a two-dimensional array or in an advanced array property....
Middle (Function)
Extracts: a substring from a string starting at a specified position. part of a buffer starting at a specified position....
iPrintBlock (Function)
Forces a report block to print.
Renaming a project
Renaming a project is used ton modify the name of the project. All the elements linked to the project before it is renamed are kept.
HOptimize (Function)
Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter.
fCopyFileWebFolder (Function)
Copies an image file from the data directory of application (or from one of its sub-directories) to the "_WEB" directory of application (or to one of its sub-directories).
Unicode (Property)
The Unicode property is used to: Determine if the value of a control is a Unicode string. Specify whether the value of a control is a Unicode string....
IntegerToDate (Function)
Converts an integer into a date in YYYYMMDD format.
grSaveParameter (Function)
Saves the parameters of a chart in the format of a compressed string.
iListNestedReports (Function)
Returns: the list of nested reports currently printed (reports run by iPrintReport in one of the processes of the report currently printed). the list of sequenced reports currently printed (iSequenceAdd)....
fOpen (Function)
Opens an external file (ANSI or UNICODE) in order to handle it through programming.
dArc (Function)
Draws an arc of circle or an arc of ellipse: in an Image control, in an Image variable, in a WDPic variable (on the background layer), in a picLayer variable....
Close (Function)
Closes a WINDEV window (and returns a value if necessary).
Dialog (Function)
Displays a message box and returns the value of the button clicked by the user.
The Edit control
The Edit control allows users to enter data......
'Image gallery' Looper control
The "Image gallery" Looper control is used to manage the display of a set of images without programming......
Table control based on a data file
A Table control based on a data file is a control whose columns are bound to the items of a data file or query (data source)......
The Static Text control
A Static Text control is a control used to display a static text......
The Multimedia control
The Multimedia control is used to play multimedia files......
HTML 5: Example for managing the programmed Drag and Drop
To make a WEBDEV site more interactive, you have the ability to implement Drag and Drop in the pages....
Customizing the Switch controls
The Switch control is a 2-state Check Box control (on/off, true/false, yes/no)......
Constant
The constants are language elements whose value is fixed once and for all...
EmailOpenMail (Function)
Opens the default messaging software: of Web user on the browser computer. of the user on the current Windows computer. on the phone....