ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
Linking a Table control to a data file or query
A Table control can be used to display the content of a data file or query...
Creating an executable: Data file directory
Two types of directories can be configured when creating the executable...
Generating a description of a data file from a window or from a page
When you design a quick prototype, you often create windows (or pages) without defining any data files...
Looper control linked to a data file
A Looper control can be used to display the content of a data file or query...
How do I run through a data file?
Analysis: Description of data file structure
The analysis allows you to define the structure of data files used by the project...
HDescribeLink (Function)
Describes a link between two data files programmatically.
HListWatchedFiles (Function)
Returns the list of data files watched by HWatch.
HOpen (Function)
Opens a data file.
HSavePosition (Function)
Stores the current file context (current record, filter, pointers).
<Connection variable>.ListWatchedFiles (Function)
Returns the list of data files watched by HWatch.
HExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
HListSynonym (Function)
Returns the list of synonyms used by a full-text index.
<Source>.SetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
<Source>.Read (Function)
Reads a record in a file according to a given record number.
HDescribeFile (Function)
Describes a data file programmatically.
<Source>.ReadLast (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.ListItem (Function)
Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
<Source>.ListSynonym (Function)
Returns the list of synonyms used by a full-text index.
HFTListWord (Function)
Lists the words of the current record that will be taken into account by the full-text indexing.
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.
Managing connections
WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection...
<Source>.Out (Function)
Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HWatch (Function)
Trigger monitoring of 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.
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Source>.WatchStop (Function)
Stops watching a data file on an HFSQL server.
HRestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
<Source>.ExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
<Source>.Last (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.ListSpatialKeys (Function)
Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
HReadNext (Function)
Sets the position on the next data file record according to a browse item.
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
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.
<Source>.UnlockFile (Function)
Unlocks the records of a data file:
  • locked by HLockFile.
  • individually locked by a locking read function.
fDataDir (Function)
Returns the full path of the directory of HFSQL data files specified by the user when installing the application.
<Source>.Found (Function)
Checks whether the current record corresponds to the current filter or search.
HCancelAlias (Function)
Cancels an alias that was declared beforehand by HAlias.
HUnlockRecNum (Function)
Unlocks a record locked by:
  • HLockRecNum,
  • a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
HListLink (Function)
Returns the list of data file bindings (Merise type) present:
  • in the current analysis,
  • in ongoing analyses (projects with multiple analyses).
  • in a specific analysis.
HWatchStop (Function)
Stops watching a data file on an HFSQL server.
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<Source>.ExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
<Source>.GetCurrentPosition (Function)
Returns the approximate position of current record in the data file.
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
HFound (Function)
Checks whether the current record corresponds to the current filter or search.
HLast (Function)
Sets the position on the last record of a data file according to a browse item.
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.
<Source>.NoModif (Function)
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy).
<Source>.ReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
HDeleteAll (Function)
Deletes all records from a data file, an HFSQL view or a query.
<Source>.CreateView (Function)
Creates an HFSQL view.
This function uses the former view mechanism.
<Source>.Previous (Function)
Sets the position on the previous record of the data file according to a browse item.
HDescribeFullTextIndex (Function)
Describes a full-text index of data file created programmatically.
<Source>.RecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
<Source>.UnlockRecNum (Function)
Unlocks a record locked by:
  • HLockRecNum,
  • a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
<Source>.DeleteAll (Function)
Deletes all records from a data file, an HFSQL view or a query.
<Source>.Next (Function)
Sets the position on the next data file record according to a browse item.
HUnlockFile (Function)
Unlocks the records of a data file:
  • locked by HLockFile.
  • individually locked by a locking read function.
<Source>.DescribeFile (Function)
Describes a data file programmatically.
<Source>.RetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
<Source>.First (Function)
Sets the position on the first record of a data file according to the specified browse item.
HErrorLock (Function)
Used to check whether a lock error occurred.
HListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Source>.ExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
HReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
<Source>.DeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
<Source>.Delete (Function)
Deletes a record from a data file (query or view).
<Source>.ReadNext (Function)
Sets the position on the next data file record according to a browse item.
<Source>.Open (Function)
Opens a data file.
<Source>.RestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
<Source>.Reset (Function)
Initializes:
  • one or all variables of file items with their default values.
  • one or all items of a Record variable with their default values.
HEndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
Application triggers
A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file.
<Source>.Close (Function)
Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user.
HDBCreation (Function)
Ends the description of the structure of an xBase data file programmatically.
HPrevious (Function)
Sets the position on the previous record of the data file according to a browse item.
<Source>.DeactivateFilter (Function)
Temporarily disables the filter on a data file (view or query).
HCreateView (Function)
Creates an HFSQL view.
This function uses the former view mechanism.
<Source>.ListLink (Function)
Returns the list of links (Merise) in the current analysis or in a specific analysis.
<Source>.ExportJSON (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
HExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
HExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
HFirst (Function)
Sets the position on the first record of a data file according to the specified browse item.
HOut (Function)
Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
<Source>.SavePosition (Function)
Stores the current context of a data file: current record, filter, read pointers.
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
HReadLast (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.ListKey (Function)
Returns the list of keys in a data file (query or view) recognized by the HFSQL engine.
HFilter (Function)
Defines and enables a filter on a data file, view or query.
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile support NULL values in items of HFSQL data files and for all other types of access (Native, OLE DB...
HWrite (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
HDelete (Function)
Deletes a record from a data file (query or view).
<Source>.Watch (Function)
Trigger monitoring of 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.
HDescribeSemanticIndex (Function)
Defines a semantic index of a data file created programmatically.
HSetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
<Source>.FTListWord (Function)
Lists the words of the current record that will be taken into account by the full-text indexing.
HDeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
HRead (Function)
Reads a record in a file according to a given record number.
HNext (Function)
Sets the position on the next data file record according to a browse item.
HRecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
HGetCurrentPosition (Function)
Returns the approximate position of current record in the data file.
<Source>.ExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
HDeactivateTrigger (Function)
Disables a trigger.
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.
HListKey (Function)
Returns the list of keys in a data file (query or view) recognized by the HFSQL engine.
HClose (Function)
Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user.
HDeactivateFilter (Function)
Temporarily disables the filter on a data file (view or query).
HNoModif (Function)
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy).
HDescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL data file.
HListSpatialKey (Function)
Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
Zombie data files and items
During the life of an application, items live and die...
<Source>.EndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
HExportJSON (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
HReset (Function)
Initializes:
  • one or all variables of file items with their default values.
  • one or all items of a Record variable with their default values.
HExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
Using Unicode in HFSQL data files
The analysis proposes two types of Unicode items ...
<Source>.Filter (Function)
Defines and enables a filter on a data file, view or query.
<Source>.Write (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
<Source>.DescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL data file.
HDescribeItem (Function)
Describes a file item programmatically.
Describing a report table
To display the table description, select "Table description" in the context menu of one of the table elements...
Constants for managing Big Data Redis databases
Sort the data displayed in your tables in one click
Accessing an LDAP directory
An LDAP directory is used to share information databases on a local or external network....
3. Dates, arrays and structures
WINDEV Mobile Tutorial - WLanguage basics Lesson 3 - Dates, arrays and structures - 20 min
Application patch
Once an application was installed, the application library had to be reinstalled whenever a modification was performed (WDL file)......
Shared memory areas
WINDEV, WEBDEV and WINDEV Mobile allow you to handle shared memory areas......
StringToArray (Function)
Fills a one- or two-dimensional array of the specified type with the character string passed in parameter.
AnchorRateHeight (Property)
The AnchorRateHeight property is used to: Find out the vertical anchor rate of a control. Modify the vertical anchor rate of a control....
Associating documents with the project
To describe a project in detail, you can associate documents with it......
BurnerAddDirectory (Example)
Usage example of the BurnerAddDirectory function
Multiselection (Property)
The Multiselection property gets and sets the selection mode: in a Table and TreeView Table control. in a Pivot Table control. in a List Box and ListView control. in a Looper control. in a Calendar control. of files in an Upload control....
ERR_PARSER
SCM: Optimizing the time management
From version 110042, the dates and times are stored in the Source Code Manager in UTC format (Universal Time Coordinates) instead of local computer time......
3. Types of accessible files
2. Types of accessible files
Types of accessible files...
FilterProcedure (Property)
The FilterProcedure property allows you to get and modify the procedure used to apply a filter on a row or column header when calculating a Pivot Table control.
ListDLL (Function)
Returns: at runtime: the list of libraries (".DLL" files) used by the current WINDEV or WINDEV Mobile application or by the current WEBDEV site. Only the libraries loaded in memory are listed. in test mode: all the libraries installed on the current computer....
fParentDir (Function)
Returns the path of the parent directory for the specified directory.
TreeMapSearch (Function)
Finds the index of an element in a TreeMap control from the element path.
TreeMapSeek (Function)
Finds the index of an element in a TreeMap control from the element path.
<TreeMap>.Seek (Function)
Finds the index of an element in a TreeMap control from the element path.
Deep links to mobile applications
Deep linking allows you to redirect the user to specific content in a mobile application (rather than in a browser) when they click on a link in a web page or in an email......
Replication management functions
Three types of replication are proposed......
FinPeriodInterest (Function)
Calculates for a given period the amount of interests due for a loan paid off by fixed periodic payments with a fixed interest rate.
1
…
105
106
107
108
109
…
217
>