ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
SQLLock (Function)
Used to lock:
  • The entire data table, in read and write mode. Its data cannot be accessed by other computers.
  • The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.
HSetMemo (Function)
Used to modify the management mode of memo items.
fLongName (Function)
Returns the long name of a file or directory.
HErrorModification (Function)
Allows you to:
  • return the value of a record item if a modification conflict occurs.
  • check if a modification conflict occurred.
Creating the Relation pages of a WEBDEV RAD pattern
Referring to an element in a WLanguage event / process
EmailReadMessage (Example)
Usage example of the EmailReadMessage function
<Source>.StatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
HToItem (Function)
Assigns the specified value to an item of the current record.
HStatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
fShortPath (Function)
Returns the full short path of a file or directory.
HActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
HSetREP (Function)
Enables or disables the management of .REP files.
Data Source (Variable type)
A Data Source variable is used to describe a temporary data source (query, view, alias, etc.).
<DiskFile variable>.FileName (Function)
Returns the name of an external file currently open.
HCancelDeclaration (Function)
Allows you to:
Writing an email
Writing an email in WLanguage consists in filling the email structure of WLanguage...
fAttribute (Function)
Returns or modifies the attributes of a file.
fShortName (Function)
Returns the short name of a file or directory.
<Source>.ToItem (Function)
Assigns the specified value to an item of the current record.
dLoadImage (Function)
Loads an image in an Image variable from a memo, a file or a binary buffer.
<Source>.InfoMemo (Function)
Returns the characteristics of binary and text memos.
<Source>.ActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
fTempFile (Function)
Returns the name of a unique temporary file.
fFind (Function)
Finds a character string or a buffer in a file opened by fOpen.
Analysis editor: Handling a data file
The main operations that can be performed on a data file from the data model editor are as follows ...
fFileExist (Function)
Checks the existence of an external file.
<Word Processing>.Open (Function)
Opens a Word Processing file (docx format) in Read/Write mode. The docx file is opened and locked until it is closed.
TableToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
HViewToFile (Example)
Example of function use HViewToFile
<Source>.DescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL data file.
<Source>.ToWindows (Function)
Automatically initializes the controls of a window with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
External language: Java programming
We are going to call the elements developed in WINDEV (project, windows, analysis, ...
Managing HFSQL Client/Server applications
The HFSQL Control Center is used to manage the HFSQL Client/Server servers and the HFSQL Client/Server databases...
HTriggerRecordBefore (Function)
Retrieves the value of the current record before the trigger(s) are executed.
Data persistence
The data persistence is used to store the value typed by the user...
zipExtractFile (Function)
Extracts a file from an archive and automatically decompresses it to a physical location or in memory.
<Image>.SaveJPEG (Function)
Saves an image:
  • in a JPEG file.
  • in memory.
WLanguage procedure called by CameraRunApp
WLanguage procedure ("callback") called when taking photos or recording videos via CameraRunApp.
HOnError (Example)
Usage example of the HOnError function
<Diagram variable>.Save (Function)
Saves a diagram as a "diag" file.
fSelect (Function)
Opens the Windows file picker.
DiagramSave (Function)
Saves a diagram as a "diag" file.
<Diagram Editor>.Save (Function)
Saves a diagram as a "diag" file.
<HTML editor>.ToPDF (Function)
Exports the content of an HTML Editor control to a PDF file.
HTMLEditorToPDF (Function)
Exports the content of an HTML Editor control to a PDF file.
HLinkMemo (Function)
Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
HForward (Example)
Usage example of the HForward function
fExtractResource (Function)
Extracts a resource from the application into a physical device location.
<Source>.SeekLast (Function)
Sets the position on the last file record whose value for a specific item is less than or equal to a sought value.
DnDCacheData (Function)
Indicates the type of data and the data to copy/move during Drag/Drop.
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.
7. HFSQL: Physical files
WX file
The "Executable Name".WX file is used to manage some features directly, even if these features have not been included in the application. This file is found beside the executable.
7. HFSQL: Physical files
7. Creating HFSQL data files: Physical files
The data model editor allows you to define the structure of the data files.
HCreateMovableReplica (Function)
Creates a movable replication.
Handling WEBDEV Account Manager via command line
All the features in WEBDEV Account Manager can be used via command line...
HOnError (Function)
Customizes the management of HFSQL errors.
Native xBase/FoxPro Connector
WINDEV and WEBDEV offer a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module...
FOR EVERYTHING: chain routes
The FOR EACH statement is used to browse strings according to different methods:
  • Browse the substrings separated by a separator.
  • Finding the occurrences of a string inside another string.
HReadLast (Example)
Usage example of the HReadLast function
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
iPrintPDF (Function)
Prints the content:
  • of a PDF file.
  • of a buffer containing a PDF.
  • of a PDF Reader control.
Defining specific character sets in HFSQL data files
When an application displays or saves data in HFSQL data files, this data is typed in the current language...
<Source>.OnError (Function)
Customizes the management of HFSQL errors.
How to include secure payment in a WEBDEV website?
This help page explains how to add a secure payment into a WEBDEV website...
PhotoRunApp (Function)
Starts the native camera application of the device in order to take a photo.
Optional events: Information retrieved
In WINDEV, you can add optional events in the code of the different elements of an application...
HInfoMemo (Function)
Returns the characteristics of binary and text memos.
fDataDir (Function)
Returns the full path of the directory of HFSQL data files specified by the user when installing the application.
BuildBrowsingTable (Function)
Creates a Table control from the items of a data file (view or query).
HListKey (Function)
Returns the list of keys in a data file (query or view) recognized by the HFSQL engine.
fCompress (Function)
Compresses a file.
InitParameter (Function)
Initializes the management of persistent values.
ImageInfoValue (Function)
Returns the value of an Exif tag for the image used.
fMoveFile (Function)
Moves a file from one directory to another.
HPass (Function)
Defines the password used to create or open a data file.
<Source>.Backward (Function)
Moves backward several records from the current position in the data file, according to a specified item.
<Connection variable>.InfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server data file.
HBackward (Function)
Moves backward several records from the current position in the data file, according to a specified item.
SQLExec (Function)
Names and runs an SQL query.
<Source>.Password (Function)
Defines the password used to create or open a data file.
Reset (Function)
Reinitializes:
  • all the controls found in the current window or page (including the groups of controls, the supercontrols and the internal windows).
  • the controls found in a group of controls, a supercontrol, an internal window or an internal page.
picRTF (Variable type)
The picRTF type is used to define all the advanced characteristics of a layer that contains RTF.
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
HErrorInfo (Function)
Returns a detailed information about the last error triggered by the HFSQL engine.
<Window>.FromSource (Function)
Automatically initializes the controls of a window with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
picText (Variable type)
The picText type is used to define all the advanced characteristics of a Text layer.
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.
HelpFile (Function)
Returns or modifies the name of the help file used by the context-sensitive help of a window.
Display (External language)
Displays a value in a control or assigns a value in a variable.
SourceToScreen (Function)
Automatically updates the controls in a window or page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
HMode (Function)
Changes the mode and the method for locking data files.
<Source>.LinkMemo (Function)
Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
<Tiff variable>.SaveTIFF (Function)
Saves an image in TIFF format into a file or memory.
Manipulating TimeLine controls programmatically
A TimeLine control can be...
How do I run through a data file?
ControlAlias (Function)
Gets, modifies or restores the data binding to a control or group of controls.
DB2 Native Connector: Features and notes
The following paragraphs present the main aspects and specific features of the Native DB2 Connector...
fAttributeReadOnly (Function)
Gets and sets the read-only attribute of a file.
<Source>.Mode (Function)
Changes the mode and the method for locking data files.
<Source>.LockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
hFileParameter (Variable type)
The hFileParameter type is used to define the data files taken into account by a scheduled optimization task.
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
fImageSelect (Function)
Opens the image picker of Windows.
dbgSaveDebugDump (Function)
Saves a dump file of the application.
HDeclare (Function)
Declares a description of data file (found in an analysis) in the current project.
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) ...
BarCodes (Variable type)
The BarCodes type is used to handle the information found in a bar code.
fLoadBuffer (Function)
Loads the content of an external file (text, image, ...) in a buffer variable.
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
Manipulating Image Editor controls programmatically
WINDEV allows you to programmatically manipulate Image Editor controls...
HModifyStructure (Function)
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).
fWatchDirectory (Function)
Detects changes made to the contents of a directory.
WindowFromSource (Function)
Automatically initializes the controls of a window with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
<Source>.ModifyStructure (Function)
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).
<Table>.ToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
HCheckStructure (Function)
Defines the mode for comparing data files.
<TreeView>.Add (Function)
Adds a "leaf" element (and all necessary nodes) into a TreeView control.
Sound (Function)
Plays a sound in WAV format.
<Source>.ChangeName (Function)
Modifies the physical name of a data file.
Report based on a Looper control
A report based on a Looper control is used to directly print the information displayed in the control...
zipExtractFileList (Function)
Extracts and decompresses a list of files found in an archive to a physical location.
External language: Programming in C#
We are going to call the elements developed in WINDEV (project, windows, analysis, ...
TreeAdd (Function)
Adds a "leaf" element (and all necessary nodes) into a TreeView control.
HChangeName (Function)
Modifies the physical name of a data file.
Batch processing: creation of executables, WDLs, components, etc.
WINDEV and WEBDEV allow you to perform multiple types of processes from a command line...
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.
HExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
HAccelerateSpeed (Function)
Reorganizes the internal structure of the indexes to optimize the speed for accessing the data.
Report based on a memory area
A report based on a memory area is used to print the records stored in a memory area...
Implementing the log process in an application
Regardless of the data files used by your application (HFSQL Classic or HFSQL Client/Server), the log process can be implemented on these data files...
fUncompress (Function)
Decompresses a file that was compressed by fCompress.
Reintegrating translated text into a project
Once the translation of framework libraries ("...
CertificateLoad (Function)
Loads a certificate from a file or a buffer.
HCreateSubscriberReplica (Function)
Creates the description file of a subscriber replica.
HModify (Example)
Usage example of the HModify function
HSubstDir (Function)
Associates the data directory specified in the analysis with a directory found on disk.
<Email variable>.BuildSource (Function)
Generates the source code of the email to send from an Email variable.
Manipulating TimeLine controls programmatically (prefix syntax)
A TimeLine control can be...
<Source>.DeleteAll (Function)
Deletes all records from a data file, an HFSQL view or a query.
KeyPressed (Function)
Checks which key is pressed.
SchedulerAddResource (Function)
Adds a new resource into a Scheduler control.
fListFile (Function)
Lists the files found in a directory and returns the list of files.
<Source>.RetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
HWatch (Function)
Starts monitoring write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered.
HDeleteAll (Function)
Deletes all records from a data file, an HFSQL view or a query.
HSetDuplicates (Function)
Enables or disables the management of duplicates on a unique key.
HDBIndex (Function)
Opens an xBase index file.
<Source>.ExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
iPrintWord (Function)
Sends the character string passed in parameter to the print buffer.
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...
HRetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
<Source>.Watch (Function)
Starts monitoring write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered.
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...
fCreateLink (Function)
Creates a link on a file at the specified location.
<Source>.CancelDeclaration (Function)
Allows you to:
iSequencingAddPDF (Function)
Adds a print of PDF document into a sequence of report prints.
<Source>.SetDuplicates (Function)
Enables or disables the management of duplicates on a unique key.
2024 novelties brochure: Common novelties
What's new in WINDEV/WEBDEV/WINDEV Mobile 2024 in the 2024 New Features brochure.
DocUpdateTableOfContents (Function)
Updates the table of the contents of a document.
WINDEV 2026: New WLanguage features
Version 2026 includes new and improved functions, properties and data types, ...
WindowBitmap (Function)
Creates the image of the specified window in a BMP file.
<Window>.WindowBitmap (Function)
Creates the image of the specified window in a BMP file.
NetworkDisconnect (Function)
Disconnects a network drive.
Translating a text file with WDTRAD
AAFImportParameter (Function)
Loads all customizations made via AAFs (Automatic Applications Features) that have previously been saved to a file.
AAFExportParameter (Function)
Saves all customizations made via AAFs (Automatic Application Features) in a file.
RTFLoad (Function)
Loads a file in RTF in an RTF control (found in a window or in a report).
HChangeConnection (Example)
Usage example of the HChangeConnection function
HListFile (Function)
Returns the list of files:
  • current analysis.
  • analyses in progress (projects with multiple analyses).
  • a specific analysis recognized by the HFSQL engine.
  • available on a connection via a Native Connector or an OLE DB driver.
  • for a group of files defined in the data model editor.
WLanguage procedure called by zipAddDirectory to handle the progress bar
WLanguage procedure ("Callback") used by zipAddDirectory to manage the progress of files being added to the archive.
dSaveImageTIFF (Function)
Saves an image in TIFF format into a file or memory.
AAFChangeCaption (Function)
Customizes the text of a menu option for context menus corresponding to an AAF (Automatic Application Feature).
Manipulating Gantt Chart controls programmatically
2026 new features brochure: WINDEV new features
What's new in WINDEV 2026 in the What's new 2026 brochure.
Data model editor: Types of items
The different types of items proposed in the data model editor are as follows:
fCopyFile (Function)
Copies one or more files (regardless of their attributes).
OBEXSendFile (Function)
Sends a file to a device that supports the OBEX protocol.
TwainToBMP (Function)
Allows you to perform one of the following actions:
  • save the document coming from the Twain device in a Bitmap file (".BMP" extension).
  • view the document coming from the Twain device in the user interface of the device.
  • save the document coming from the Twain device directly in memory in Bitmap format (in a buffer).
HSynchronizeReplica (Function)
Synchronizes the master replica and the subscriber replica: the operations performed on one of the replica are transferred into the other replica.
TwainToGIF (Function)
Allows:
  • save the document coming from the Twain device in a GIF file.
  • view the document coming from the Twain device in the user interface of device.
  • save the document coming from the Twain device directly in memory in GIF format (in a buffer).
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
TwainToJPEG (Function)
Allows:
  • save the document coming from the Twain device in a JPEG file.
  • view the document coming from the Twain device in the user interface of device.
  • save the document coming from the Twain device directly in memory in JPEG format (in a buffer).
2026 novelties brochure: WEBDEV novelties
WEBDEV 2026 new features in the 2026 New Features brochure.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HListItem (Function)
Returns the list of items:
  • found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • found in a Record variable.
Remote deployment via FTP or HTTP
Associative array (Variable type)
An associative array is an "advanced" type of array...
WINDEV Mobile new features brochure 2026
What's new in WINDEV Mobile 2026 is presented in the What's new 2026 brochure.
WINDEV Mobile 2026: New WLanguage features
Version 2026 includes new and improved functions, properties and data types, ...
Managing emails with "Simple MAPI"
Simple MAPI simplifies the management of emails received by the hosting provider...
1
…
8