ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2025
Table,Modify (External language)
Modifies an element in a Table control.
GeometryLength (Function)
Calculates the length of a given geometry.
GeometrySymmetricDifference (Function)
Calculates the symmetric difference between two geometries.
<Table>.ModifyLine (Function)
Modifies a row in:
  • a Table control,
  • a TreeView Table control.
The log process
A log is a special file that contains the history of all changes made to one or more tables over a given period of time (date the table was created, last automatic data modification, last backup created with WDLog, etc.)
Native XML Connector
WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor...
<Chart>.DeleteSeries (Function)
Deletes a data series from a chart.
LooperRefreshVisible (Function)
Changes or returns the visibility status of the refresh bar in a Looper control.
WDOptimizer: Presentation
The different operations that can be performed with WDOptimizer are as follows...
iCalendarToOrganizer (Function)
Imports data in iCalendar format into an Organizer control.
<sshSession variable>.Read (Function)
Reads the data found on the output buffer of the SSH session.
<Looper>.RefreshVisible (Function)
Changes or returns the visibility status of the refresh bar in a Looper control.
Metatypes in the database schema
A metatype is a combination of characteristics of an item and a bound control...
Types of pages
WEBDEV enables you to create static sites and/or dynamic sites...
SQLListSource (Function)
Lists the data sources declared on a local site.
Creating a delete query
A delete query (corresponding SQL statement...
Table,Add (External language)
Adds an element to a Table control.
Connection (Property)
The Connection property gets and sets the connection associated with a table.
TelemetryIdentifyUser (Function)
Identifies the current user for whom the telemetry data is saved.
Binding a Link control to an item
The mongoOperationUpdateAll type is used to define all the advanced characteristics of a document update operation that will be added to a bulk operations list. All the documents that match the selection filter will be updated.
MobileNetworkStatus (Function)
Returns the current status of the connection to data on the mobile network or asks to be notified when the status of the connection to data changes.
<PolygonGeo variable>.Intersect (Function)
Checks whether the intersection of a geographic polygon and another geometry does not result in an empty set.
GeometryConvexHull (Function)
Calculates the convex hull of the specified geometry.
TableRecNum (Function)
Returns the number of the current record in a data-bound Table control based on a table.
grRBMaximumValue (Function)
Sets the maximum value in a Radial Bar chart.
WebserviceReadMIMEType (Function)
Returns the MIME type of the request received when calling a REST web service.
CmdGetExitCode (Function)
Gets the exit code of the command executed in console mode, i.e. the value returned when the command finishes executing.
Page constants
List of constants used by page functions.
LooperToXML (Function)
Creates an XML file with data from a Looper control (Looper control based on a table or populated programmatically).
Defining colors in Table controls
The colors of a Table control (row background, text of rows, etc.) are defined in the control description...
Coloring a row, a column or a cell found in a control (AAF)
To simplify the reading in the controls used to view large volumes of data, the end user has the ability to color the data found in the control...
grScatter3DAddData (Function)
Adds a new point to display in a 3D Scatter chart.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
Error 1009: The member of the class is private
Constants for managing the multi-touch
TableSelectPlus (Function)
Selects a row in a Table or TreeView Table control.
<Looper>.SearchEverywhere (Function)
Searches for a value in all the attributes of a Looper control.
<TreeView>.SelectCount (Function)
Returns the number of selected elements in a TreeView control (for a multi-selection TreeView control).
Configuring the assisted universal replication
If your application uses assisted universal replication via a .WER file, the setup creation wizard proposes to configure the setup to install the different tools required for this type of replication.
Snap to grid
The different editors of WINDEV, WEBDEV and WINDEV Mobile allow you to align the elements via a snap-on grid...
zipDeleteFileList (Function)
Deletes a list of files from an archive.
9. Queries
Reads the data found on the output buffer of the SSH session.
Keyword properties
You can change the characteristics of a keyword at any time in the keyword properties...
1. Application overview
WINDEV Mobile tutorial: Developing an Android and iOS application Lesson 1 - Application overview - 10 min
HCreateServerTrigger (Function)
Adds or modifies a server trigger on the HFSQL server.
Specific features of iPhone/iPad applications
To simplify the reading in the controls used to view large volumes of data, the end user has the ability to zoom the data found in the control...
How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Setup by stand-alone physical media
A setup by stand-alone physical media allows you to provide a media that contains all the files required for installing and running a site...
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items...
Defining specific character sets in HFSQL tables
When an application displays or saves data in HFSQL tables, this data is typed in the current language...
<PolygonGeo variable>.SerializeWKT (Function)
Serializes a geographic polygon using the Well-Known Text (WKT) format.
StatAverage (Function)
Calculates the arithmetic, geometric or harmonic mean for a series of values.
FTPCommand (Function)
Sends a specific FTP command to a server.
Count (Property)
The Count property returns the number of elements in a given set.
WEBDEV: Pages created by the RAD "pages"
The page creation wizard shows different types of pages associated with HFSQL tables...
FileToPage (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the table described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
  • the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
MultiPoint2D (Variable type)
The MultiPoint2D type is used to store a set of points defined with 2D coordinates. It is a collection of points: unlike in a linestring, points are not connected.
6. Printing the product catalog
WINDEV Mobile Tutorial - Developing an Android and iOS application Lesson 6 - Printing the product catalog - 20 min
Replication of HFSQL servers (Programming)
To implement a replication of HFSQL servers through programming, WLanguage...
Spatial data functions (prefix syntax)
Lit la valeur d'un des paramètres d'animation défini pour un champ Image.
Looper controls populated programmatically: Operations in WLanguage
Here is an overview of how to handle Looper controls populated programmatically in WLanguage.
Cardinalities (Data model editor)
Cardinalities are used to count the relationships between two tables....
Zombie tables and items
During the life of an application, items live and die...
Comparing the project messages
The comparison between source and target text helps you find translation errors...
Describing a report table
To display the table description, select "Table description" in the context menu of one of the table elements
REST web service: Calling a web service function
RESTSend is used to call a REST webservice function.
Zoom in the different editors
All editors of WINDEV, WEBDEV and WINDEV Mobile allow you to zoom in on the different elements displayed in the editor...
LooperStartFilling (Function)
Starts the process to populate a Looper control programmatically.
Operations performed on sequence diagrams
The following paragraphs explain...
spDerivation (Property)
The spDerivation property is used to:
  • Get the key derivation function used to hash an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Set the key derivation function used for hashing (only for "Password" items defined programmatically).
AJAXExecuteAsynchronous (Function)
Runs a server procedure without refreshing the page.
Configuring the browser "Back" button
The "Back" button allows users to see the history of pages they previously visited...
Functions for handling commands in console mode (prefix syntax)
Functions for handling commands in console mode.
<Page>.FromFile (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the table described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
  • the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
Handling XLS files (prefix syntax)
WINDEV and WEBDEV propose two methods for handling Excel files...
Copying controls from the page editor
The controls can be copied from the page editor...
The Sidebar control
The Sidebar control gives access to different options...
Binding a Scrollbar control to an item
A scrollbar can be bound to an item in a table, query, etc.
StatMin (Function)
Calculates the minimum value for a series of values.
Error 107: Redefinition of the parameter
The Notification keyword can correspond to:
Project description: Theme tab
The project description window allows you to configure various elements of your project...
Error 530: The -- operator is not allowed
To simplify the reading in the controls used to view large volumes of data, the end user has the ability to zoom the data found in the control...
IIS Version 7 to 10
Returns the list of files found in an archive.
Manager of automated tests
The test manager is used to...
KeyExpression (Property)
The KeyExpression property is used to set the different components of a composite key.
LooperSearchEverywhere (Function)
Searches for a value in all the attributes of a Looper control.
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
Information 2102: 'Long' does not exist anymore: the integers are coded on 4 bytes
Downloads a file from a remote drive to the user's computer.
Internal component description
The description of an internal component can opened at any time...
NotesReset (Function)
Creates an empty document in Lotus Notes.
Programming overview in C and C++
Several print modes are available for a report.
<Table>.Count (Function)
Returns:
  • the number of columns found in a Table or TreeView Table control.
  • the number of rows found in a Table or TreeView Table control.
DisplayedItem (Property)
The DisplayedItem property is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
grWndSize (Function)
Defines the size of the window containing the chart.
Installing a WEBDEV website with zero-downtime update
Starting with version 24, you can update a Session or AWP site without disconnecting users...
OOP concepts
A class contains the description of a data structure (members) and the processes (methods) that handle this structure.
Description of an Organizer control (control of a page)
The Organizer control can be configured in the editor via the description window ("Details" tab)...
<zipArchive variable>.ListFile (Function)
Returns the list of files found in an archive.
HInitSubscriber (Function)
Initializes the range of automatic identifiers for the description file of subscriber replica (".rpl" extension).
grSeriesColor (Function)
Initializes the color of a series or the color of a section.
docElementText (Variable type)
The DocElementText type is used to handle the characteristics of a Text element found in a DocElement variable.
mqttSession (Variable type)
The mqttSession type is used to define the parameters for connecting to the MQTT broker.
Using objects
To access a class, the object must be declared as being part of the class to handle, this is called object instantiation...
<Command variable>.ReadStandardOutput (Function)
Reads standard output data, for the command executed in console mode.
1. Deploying a static website
The Pascal string of type corresponds to a length-prefixed string (this length is stored as a byte value). This type of variable is kept for backward compatibility.
What is a database?
A database is an organized collection of data for a particular purpose (e.g., manage orders)...
Extensions of files created by WINDEV, WEBDEV, WINDEV Mobile
The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile...
WEBDEV administrator: Advanced configuration
The "Advanced" tab enables you to configure advanced options of the server...
grLineThickness (Function)
Retrieves and/or modifies the value of the line thickness in a line chart.
<Image>.First (Function)
Displays the first image for the scroll.
3. Multi-criteria search
WINDEV Tutorial: Managing data in a WINDEV application Lesson 3 - Multi-criteria search - 40 min
1. Communication with WINDEV Mobile
WINDEV Mobile includes several communication functions for different fields.
Properties associated with reports and controls
List of properties associated with the reports and their controls
<Connection variable>.DescribeServerTrigger (Function)
Adds or modifies a server trigger.
Twain constants
List of constants used by the Twain functions.
Constants for managing XML documents
List of constants used by the functions for managing XML documents.
5. User Groupware in practice
Closes the current browser window and stops the execution of the current code.
2. WEBDEV administrator in practice
Builds a sequence of characters containing a line.
The Pager control
The Pager control is used to quickly access the records of a Table or Looper control displayed on several pages...
HCreationIfNotFound (Example)
Usage example of the HCreationIfNotFound function
zipNbFile (Example)
Usage example of the zipNbFile function
Handling the external files
WINDEV, WINDEV Mobile and WEBDEV propose several functions allowing you to manage the external files from your WINDEV/WINDEV Mobile applications or from your WEBDEV sites...
<Pivot Table>.Collapse (Function)
Collapses the data found in a Pivot Table control according to a row header or to a column header.
WDContinueError: Resume after error
This function forces the execution to resume after an error...
Functions for managing Pivot Table controls (prefix syntax)
Functions for managing Pivot Table controls (prefix syntax)
4. HFSQL Classic
MyChildWindow is used to handle the child window of the current window.
MVP RAD
WINDEV proposes an MVP RAD that generates the "table" and "form" windows as well as the necessary Presenter and Model classes...
<Image variable>.Clear (Function)
Clears the content of an Image variable and fills it with the specified color.
Audits
Audits provide a set of features to automatically improve the project quality and performance, and to monitor the conditions in which it is implemented...
tapiCallStart (Function)
Returns the date and time of the beginning of call (incoming or outgoing call).
grRealTimeInterval (Function)
Sets the time interval visible in a time chart with real-time display.
MyGuidedTour
The MyGuidedTour variable is used to handle the current Guided Tour. The MyGuidedTour variable is used to get the characteristics of the GuidedTour variable used.
CookieWrite (Function)
Writes a cookie onto the computer of the Web user.
LooperSearch (Function)
Searches for a value in an attribute of a Looper control.
Maximized windows for Android
A maximized window occupies the entire screen of the mobile device.
Writing an email
Writing an email in WLanguage consists in filling the email structure of WLanguage...
10. Internal window
The Internal Window control is used to include a window (and its code) in another window. At runtime, the internal window will be dynamically merged with the host window.
OAuth and OpenID protocol functions
OAuth and OpenID protocol functions
TestCheckNull (Function)
Checks whether an expression is Null in assertive programming and in automated test mode.
HCreationIfNotFound (Function)
Performs the following operations:
  • If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
  • If the table exists, opens the table.
Referring to an element in a WLanguage event / process
Used to manage the horizontal position (X-coordinate) of print cursor in the page.
nWDInitProject: Project initialization code
Run the project initialization code...
tapiCallDuring (Function)
Returns the duration of the call (difference between the start date and time of call and the end date and time of call).
ReplicDeleteSubscription (Function)
Deletes the subscription of a replication on the replication server.
NotesOpenDatabase (Function)
Gives access to the documents managed by Lotus Notes.
1. WLanguage functions specific to WEBDEV
Seeks and retrieves the records (Salesforce objects) deleted during the specified period.
HDeleteTask (Function)
Deletes a scheduled task from an HFSQL Client/Server server.
<Source>.ExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
DeclareWebserviceContext (Function)
Used to declare a list of variables whose value will be persistent between the successive calls to a web service.
LDAPListAttribute (Function)
Lists the object attributes in an LDAP server.
NotesNbAttachment (Function)
Returns the number of files attached to an item of the current document in Lotus Notes.
Deploying an Android application
WINDEV Mobile Tutorial: Deploying an Android application 10 min
ASPExecute (Function)
Calls an external .asp script and returns the result in a string.
zipNbPartNeeded (Example)
Usage example of the zipNbPartNeeded function
TableEnumBreak (Function)
Enumerates the breaks found in a Table control.
1. Components provided with WINDEV
WINDEV is provided with projects that contain components.
ERR_DISCONNECTED_EXEC
Displays the next plane of a Sliding Banner control.
FinNetCurrentVal (Function)
Returns the net current value of investment.
Managing assertions
The main available features are as follows:
BrowserShare (Function)
Starts the device's native share functionality.
ShareCloseRequestConnection (Function)
Request connection to a remote device.t
The AWP technology (Active WEBDEV Page)
PC SOFT proposes a new technology...
String literals: single-line and multiline strings
String literals are used to represent and manipulate data as a sequence of characters. For example, string literals can be used to display information, define a constant, etc.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
TreeView Table control properties
List of properties associated with the TreeView Table control
The "Area" charts
The Area chart is used to highlight the amplitude of a change...
Decrypt (Function)
Decrypts a character string that was encrypted by Encrypt.
TwainSourceWidth (Function)
Returns the width (in millimeters) of the document captured by a Twain device.
Error 1029: The access to the base class is restricted by a protected inheritance
Informations sur un paramètre d'une API
Parameters of the procedure used by NearbyShareSend
WLanguage procedure ("callback") called by NearbyShareSend to notify whether or not the data was sent successfully.
7. Source Code Manager (SCM)
A window can:
  • Receive parameters when it is opened.
  • Return values when it is closed.
Query based on query
Queries can be based on items from another query...
<Table>.SelectMinus (Function)
Deselects a row from a Table or TreeView Table control.
<sfConnection variable>.SeekDeleted (Function)
Seeks and retrieves the records (Salesforce objects) deleted during the specified period.
ContactCreate (Function)
Displays the contact creation window of the device's native contact management application (Android, iPhone or iPad).
List of reserved words
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.
HRSListConfig (Function)
Lists the replications available on a master HFSQL server.
ScreenFirst (Function)
Defines the next control that will be in edit in the current window.
xmlSignatureVerification (Variable type)
The xmlSignatureVerification type is used to define the information required to verify an XML signature.
Print functions
List of print functions
WINDEV Mobile 2025: New WLanguage features
In version 2025, new functions, properties and data types have been introduced and some have been improved, ...
3. Dates, arrays and structures
WEBDEV Tutorial - WLanguage basics Lesson 3 - Dates, arrays and structures - 20 min
gglOverride (Variable type)
The gglOverride type is used to define information about event notification overrides.
TestCheckTrue (Function)
Checks whether an expression is set to True in assertive programming and in automated test mode.
MatFill (Example)
Usage example of the MatFill function
ImageLast (Function)
Displays the last image for the scroll.
How to retrieve the bugs or suggestions of my users?
The different Control Centers provided with WINDEV allow you to easily manage the user feedback for your applications...
WDInst: Manipulating the files to install
By default, the files to install are...
<Window>.EdDo (Window)
Runs an action (defined programmatically) and enables Undo/Redo operations on this action.
<List Box>.Insert (Function)
Inserts an element into a List Box, ListView or Combo Box control populated programmatically.
spIterationCount (Property)
The spIterationCount property is used to:
  • Get the iteration count of the hash algorithm used for an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Sets the iteration count of the hash algorithm used for an item of type "Password" (only for "Password" items described programmatically).
LogDirectory (Property)
The LogDirectory property is used to manage the directory of the log file described in the database schema.
Modifying the query content
The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...
Array (Variable type)
An array is a structured type used to group together a set of elements of the same type...
<Source>.ChangeDir (Function)
Changes the path to a table (i.e. directory in which the file will be handled).
Tutorial
A tutorial is delivered with WINDEV, WEBDEV and WINDEV Mobile...
WINDEV 2025 Update
Here are the new features and improvements that you will discover in this version...
EmulateInfo (Function)
Emulates the next call to Info and automatically clicks the "OK" button.
LDAPValidateModify (Function)
Validates the modification of an existing object in an LDAP server.
5. User Groupware in practice
An object diagram represents a set of objects and how they relate to each other at a certain moment in time...
Use WebSockets with the WebSocket server
The WebSocket protocol provides a communication channel over a TCP socket for browsers and Web servers...
1
…
6
7
8