ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
Native Progress Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to Progress ...
SQL functions: Special case
List of SQL functions: Special cases
LooperToWord (Function)
Creates a Word file (.RTF) using the data from a Looper control.
The different types of browse available in SQL
Two types of browse can be used to browse the result of a query run by SQLExec...
LooperSearch (Function)
Searches for a value in an attribute of a Looper control.
HBuildKeyValueANSI (Function)
Whatever the platform used, the data stored in HFSQL data files is in ANSI format.
ServiceStop (Function)
Stops a service.
Playing a video with the MCI functions
MCI functions are used to easily handle the media files...
HsMenu,Name (External language)
Adds a menu into the window that opens.
Display (External language)
Displays a value in a control or assigns a value in a variable.
TableToWord (Function)
Creates a Word file (.RTF) from the data found in a Table or TreeView Table control.
ControlGrayed (Function)
Grays a control or a group of controls. An animation can be set on the controls during this operation.
ControlEnabled (Function)
Enables a control or a group of controls in a window. An animation can be set on the controls during this operation.
ControlVisible (Function)
Makes a control (or a group of controls) visible in a window. An animation can be set on the controls during this operation.
BTInfoDevice (Function)
Returns specific information about a Bluetooth device.
Oracle Native Connector: Retrieve the output value of a stored procedure
The Native Oracle Connector is used to:
  • specify the input values during the call to a stored procedure.
  • retrieve the output values after a call to a stored procedure.
ControlInvisible (Function)
Makes a control (or a group of controls) invisible in a window. An animation can be set on the controls during this operation.
fDataDir (Function)
Returns the full path of the directory of HFSQL data files specified by the user when installing the application.
MemAdd (Function)
Adds an element to a memory area.
CookieRead (Function)
Retrieves the value of a cookie saved on the computer of Web user.
JSProperty (Function)
Used to handle specific features on the objects found in the current page.
zipCurrentFile (Function)
Returns the name of the archived file currently handled by the functions for adding and extracting files.
Defining colors in Table controls
The colors of a Table control (row background, text of rows, etc.) are defined in the control description...
ServiceStart (Function)
Starts a service.
HConvertX (Function)
Converts a numeric value into a binary string in order to perform a search on a numeric key.
EnumControl (Function)
Returns the name of Nth control found in the specified element.
Indirection operators
Operators { and operators } operators are used to access a field, variable, class member or data file item by dynamically constructing the name of the field, variable, class member or item...
ServiceContinue (Function)
Restarts a paused service.
ServiceWaitStatus (Function)
Waits for a service to be in a specific status.
Manipulating Edit controls programmatically
You can manipulate Edit controls programmatically...
RichEdit (Property)
The RichEdit property is used to manage the RTF (Rich Text Format) type:
  • of an edit control or Static Text control found in a window.
  • of a Static Text control found in a report.
ServiceModify (Function)
Modifies the configuration of a service according to the information given in the members of the Service variable.
Automated tests on an executable
WINDEV allows you to test a project using the corresponding executable...
SQLGetMemo (Function)
Retrieves the content of a Memo column from the query result, for the current row.
Two methods for passing parameters to a query
Two methods can be used to pass parameters to a query with parameters used in a window or in a control (List Box, Combo Box or Table control for example) ...
NetworkConnect (Function)
Associates a drive with a shared network directory.
fLongName (Function)
Returns the long name of a file or directory.
fTempPath (Function)
Returns the name of directory used to store the temporary files.
ScreenFirst (Function)
Defines the next control that will be in edit in the current window.
fSaveText (Function)
Creates and fills a text file with the content of a text control or text variable (string variable, edit control in a window, Static Text control in a report, ...).
fRename (Function)
Modifies the name of a file.
fWriteLine (Example)
fWriteLine example
RegistryDeleteKey (Function)
Deletes a subkey from the Windows registry.
ListInsert (Function)
Inserts an element in:
  • a List Box control populated programmatically.
  • a Combo Box control populated programmatically.
  • Versions 2026 and later
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    Subscription-exclusive new feature
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    New in version 2026
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
ListSeek (Function)
Search for an item in:
  • a List Box control,
  • a Combo Box control,
  • Versions 2026 and later
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    Subscription-exclusive new feature
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    New in version 2026
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
ReturnToCapture (Function)
Stops the current process and forces the input in the specified control, window or page.
TableEnumColumn (Function)
Returns the name of a column found in a Table or Treeview Table control.
LooperSort (Function)
Allows you to:
  • Sort a Looper control according to one or more attributes.
  • Sort a Looper control on all its attributes.
  • Cancel a sort that was performed beforehand (which means ignore the sort).
JavaLoad (Function)
Specifies the location of user classes required to run the Java application or the Java applet.
JavaExecute (Function)
Starts a Java application or a Java applet by invoking the "Main" method of a given Java class.
TableInputSearch (Function)
Enables input in the search area in the column title of the Table or Treeview Table control.
fExtractPath (Function)
Returns the different elements of a path: drive, directories, name and extension of the file.
fShortName (Function)
Returns the short name of a file or directory.
fTempFile (Function)
Returns the name of a unique temporary file.
PageToEmail (Function)
Emails the data found in a page currently displayed in the browser.
Data Source (Variable type)
A Data Source variable is used to describe a temporary data source (query, view, alias, etc.).
Variant (Variable type)
The Variant type is used to:
  • store any value of simple type: Boolean, Numerical (Monetary, Real, Integer, ...), Character and String, Date (Date, Time, DateTime and Duration), ...
  • store named or indexed subelements.
  • store any complex type value: structures, classes, advanced types, arrays, associative arrays, queues, stacks and lists.
  • handle the NULL value in WLanguage.
  • store interactions with ActiveX objects and Automation programming.
TableToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
State (Property)
The State property gets and sets the state of an element.
Group (Property)
The Group property is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
  • associate a control with a group of controls.
SQL Server Native Connector: Programming using SQL functions
To use an SQL Server database with the Native Connector (or "Native Access"), you can use SQL functions...
TreePosition (Function)
Displays a TreeView control from a specified element (node or leaf) or returns the name of the first element displayed in a TreeView control.
Oracle Native Connector: Execute the same query more than once
In some cases, it may be useful to run the same query multiple times while modifying one or more parameters...
ReturnedValue (Property)
The ReturnedValue property is used to:
  • Get and change the value returned by a window, page or report.
  • Get and change the value returned by an option in a Radio Button control.
Name (Property)
The property Name allows you to:
  • find out the name of the font associated with a variable of type Font.
  • know the name of a field, report or report block.
  • know the name of a field, a group of fields or a window.
  • know the name of a field, a group of fields or a page.
  • know and modify the name of a heading, data file, full-text index or semantic index.
Sorts in a report
The sort is used to organize the information displayed in the report...
CurrentWin (Function)
Identifies the window currently in edit.
Non-modal management of a window
The window that opens another window is called parent window ; the windows opened by the parent window are called child windows...
PreviousWin (Function)
Identifies the window that was in edit before the window that is currently in edit (for the same project).
Combo Box columns in Table controls
A Table control (populated programmatically, based on a data file or based on a variable) can include Combo Box columns...
HRetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
Programming Table fields linked to a data file
Here are the main points of programming Table fields linked to a data file
Table field populated programmatically: handling in WLanguage
Here is an overview of how to manipulate Table controls populated programmatically in WLanguage.
Data-bound report
A data-bound report is used to print the records coming from a single data file (HFSQL Classic or Client/Server, accessed via a Native Access, ...
SOAPPrepare (Function)
Builds the SOAP request for calling a web service function.
Handling HTML text in an Edit control
WEBDEV allows you to manipulate text in HTML via the "HTML format" option of the Edit controls and the HTML control.
Report based on a query
Queries are used to easily select records in one or more data files...
HListREP (Function)
Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the files described in the analysis.
Report based on a Table control
A report based on a Table control is used to directly print the information displayed in the control (data-bound or populated programmatically) ...
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...
HReadLast (Example)
Usage example of the HReadLast function
ServiceControl (Function)
Sends a control message to a service.
ServiceRefresh (Function)
Asks a service to re-read its configuration information.
SQLCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
ServiceInfo (Function)
Returns information regarding the configuration of a service.
Writing an email
Writing an email in WLanguage consists in filling the email structure of WLanguage...
Reading an email
This help page explains how to read an email from a WINDEV application and how to display its content in a WINDEV application.
ServiceStatus (Function)
Returns the current status of a service.
ServiceUninstall (Function)
Uninstalls a service.
iParameterExport (Function)
Allows you to configure the exports performed from the report viewer:
  • parameters for sending emails.
  • parameters for creating the different files.
SortOption (Property)
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.
WINDEV and the streams - Use example
In this example, the application must manage a video conference between two computers...
StreamConnect (Function)
Connects a stream (and the associated control) to a specific address.
WDModFic: Tool for automatic modification of data files
WDModFic is a tool for automated modification of data files on development and end-user workstations...
SQLFetch (Function)
Goes to the next row (i.e next record) of the query result.
SQLLast (Function)
Sets the position on the last row of the query result.
HSeekFirst (Function)
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
HRestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
NotesListItem (Function)
Returns the list of items for the current Notes document in Lotus Notes.
Compile (Function)
Dynamically compile a Procedure whose source code is supplied (dynamic compilation).
HSavePosition (Function)
Stores the current file context (current record, filter, pointers).
Manipulating TreeView Table controls programmatically
This page explains how to program TreeView Table controls...
SchedulerDeleteTask (Function)
Deletes a scheduled task.
dbgInfo (Function)
Returns a debug information.
LooperToExcel (Function)
Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory).
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
HAlias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
HForward (Example)
Usage example of the HForward function
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to...
HCreateMasterReplica (Function)
Creates the description file of a Master Replica (logged replication or universal replication).
WDInst: Installing an HFSQL Client/Server application
When creating the setup program of a WINDEV application that uses HFSQL Client/Server data files, WDInst allows you to...
iTextWidth (Function)
Calculates the width (in millimeters) of the text to print, according to the specified font.
iTextHeight (Function)
Calculates the height of the font for the text to print (in millimeters).
HFilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
HFilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
HFilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
SQLPrevious (Function)
Positions on the previous row of the query result.
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
zipArchivedFile (Variable type)
The zipArchivedFile type is used to handle:
  • a file contained in an archive corresponding to one of the following formats: ZIP, CAB, RAR, WDZ, 7z, TAR, gzip or TGZ (TAR.GZ).
  • a file to add into an archive.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLListTable (Function)
List all the tables that can be accessed by the connected database system.
Starting WDOptimizer in a command line
HImportText (Function)
Imports a Text file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile).
WDLog: Backup of HFSQL data files
WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application...
HStartServer (Function)
Starts an HFSQL server (this function uses the MantaManager service).
Report based on a variable (Data binding)
A report based on a variable is used to directly print the information found in a WLanguage variable...
HRead (Function)
Reads a record in a file according to a given record number.
Name (Property)
The Name property is used to get the name of an element.
SQL functions that can be used in SQL queries
The following SQL functions can be used on the queries written in SQL code (classified by theme)...
HSeekLast (Function)
Sets the position on the last file record whose value for a specific item is less than or equal to a sought value.
HInfoMemo (Function)
Returns the characteristics of binary and text memos.
HImportHF55 (Function)
Imports a Hyper File 5.5 file into an HFSQL Classic file.
Identifier (Property)
The Identifier property gets and sets the name of the current computer shown to the participants who receive the audio or video stream. This name can be a number, for example.
EmailDeleteMessage (Function)
Deletes the current email using the current protocol (POP3, IMAP, MS Exchange, Lotus Notes or Outlook).
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSeek (Function)
Sets the position on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default).
Report based on an HFSQL view
A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view...
Composite keys
A composite key is a key item containing several other items...
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
iPrintReport (Function)
Prints a report created with the report editor.
iPrint (Function)
Sends the character string passed as parameter to the print buffer.
HCreateSubscriberReplica (Function)
Creates the description file of a subscriber replica.
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
HDBCreation (Function)
Ends the description of the structure of an xBase data file programmatically.
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.
Project Management Hub: Project Management
Project Management Hub: project management (view, create, ...)
Operators on character strings
The character strings can be handled by specific WLanguage functions or by the +, [[ and ]] operators...
Class inheritance
The hierarchical organization in class and sub-class has allowed to create the notion of inheritance...
SQLExec (Function)
Names and runs an SQL query.
Size (Property)
The Size property is used to determine and change the size of an element.
TriggerScheduledTask structure
The ScheduledTask structure is used to define all the events that will define the execution of a task...
ScheduledTask structure
The ScheduledTask structure is used to define the characteristics of a scheduled task...
JavaExecuteFunction (Function)
Starts a specific static function of a given Java class.
BurnerVolumeName (Function)
Allows you to find out or modify the name of the CD or DVD to burn.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
sOpen (Function)
Opens and initializes:
  • a serial port.
  • a parallel port.
  • an infrared port.
CookieWrite (Function)
Writes a cookie onto the computer of the Web user.
ContactAdd (Function)
Adds a contact:
  • in a Lotus Notes or Outlook address book.
  • in the contacts list of your device (Android, iPhone or iPad).
The RepeatString Looper control: Customized synchronization
How to manage the synchronization between:
  • the page displayed in the browser. This page contains a RepeatString Looper control displaying records from an HFSQL data file.
  • the corresponding page context found on the server.
Native xBase/FoxPro Connector
WINDEV and WEBDEV offer a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module...
Stored procedures and queries (HFSQL Client/Server)
The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...
WEBDEV 2026: New WLanguage features
Version 2026 includes new and improved functions, properties and data types, ...
WINDEV 2026: New WLanguage features
Version 2026 includes new and improved functions, properties and data types, ...
WINDEV Mobile 2026: New WLanguage features
Version 2026 includes new and improved functions, properties and data types, ...
NumHelp (Function)
Returns the number of the help context associated with the specified control.
OLELoad (Function)
Initializes an OLE control with an OLE object.
Sending faxes with WINDEV and WEBDEV
To send faxes from an application or from a site, WINDEV and WEBDEV propose several functions allowing you to send faxes via the system fax server available in Windows XP and Windows 2000...
EmailReadMessageHeader (Function)
Reads the header of an incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
gLink (Function)
Adds an "invisible" value to an element of a List or Combo Box control.
Function kept for compatibility. It is recommended to use gStoredValue.
EnumSubElement (Function)
Used to enumerate the subelements of a project element.
EmailReadMessage (Function)
Reads an incoming according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadMessage (Example)
Usage example of the EmailReadMessage function
ControlOver (Function)
Identifies the control hovered over with the mouse cursor.
SQLConnect (Example)
Usage example of the SQLConnect function
Manipulate OLE controls programmatically
WINDEV enables you to handle an OLE control by programming...
ListAdd (Function)
Adds an element to:
  • a List Box control populated programmatically,
  • WINDEV a Carousel field,
  • a Combo Box control populated programmatically,
  • Versions 2026 and later
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    Subscription-exclusive new feature
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    New in version 2026
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
    AndroidiPhone/iPad a Roller field.
    Warning: This field type is only available from version 2026 Update 2.
TableModify (Function)
Modifies a row in:
  • a Table control,
  • a TreeView Table control,
  • tables displayed in a Combo Box control.
BTInfoRadio (Function)
Returns specific information about a Bluetooth radio connected to the computer.
ExeInfo (Function)
Retrieves the specified information about the version of an executable or DLL.
State "form with input": input in a PDF form
The report editor can be used to create form reports, which include different controls allowing users to enter data...
Creating the Form pages of a WEBDEV RAD pattern
Creating the Table pages of the WEBDEV RAD pattern
SAP ASE Native Connector (Sybase): Programming using SQL functions
The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis...
Progress Native Connector: Programming using SQL functions
The use of SQL functions to handle Progress data does not require importing the file structure into the analysis...
Informix Native Connector: Programming using SQL functions
The use of SQL functions to manipulate Informix data does not require importing the file structure into the analysis...
DB2 Native Connector: Programming with SQL functions
The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis...
Report based on a memory area
A report based on a memory area is used to print the records stored in a memory area...
Table control based on a variable
A Table control based on a variable is a Table control whose columns are bound to the elements of an Array variable, to the members of a class or to the elements of an advanced variable (e.g., xlsDocument)...
PostgreSQL Native Connector: Programming with SQL functions
You can use SQL functions to handle the PostgreSQL database...
DB2 Native Connector: Programming with HFSQL functions
To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV analysis...
MySQL Native Connector: Programming with SQL functions
The SQL functions can be used to handle the MySQL database...
Report based on a text file
In a report based on a text file, the information to print is read from a text file or is directly assigned in the report controls...
HPrepareQuery (Function)
Initializes a query and declares this query to the database server in order to optimize the next executions of this query.
HReadSeekLast (Function)
Sets the position on the last record whose value for a specific item is less than or equal to the search value (exact-match search).
HReadSeek (Function)
Sets the position on the first record of the data file whose value for a specific item is greater than or equal to the search value (generic search).
HReadSeekFirst (Function)
Sets the position on the first record whose value for a specific item matches exactly the search value (exact-match search).
ChangeSkinTemplate (Function)
Dynamically changes the skin template:
  • of all windows found in the current application,
  • of the windows found in the WINDEV components used by the application,
  • of a specific window found in the project.
Assignment operators
Three assignment operators are available...
HClusterParameter (Function)
Reads and modifies the parameters of an HFSQL cluster.
1
…
8