ONLINE HELP
 WINDEVWEBDEV 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.
InJavaMode (Function)
Indicates whether the code is run in Java.
SysNameExe (Function)
Returns the name and full path of an application.
eExchangeRate (Function)
Returns the value of the exchange rate for a currency.
ErrorPropagate (Function)
Propagates a non-fatal error that can be processed by the calling code if the management of non-fatal errors was enabled for this code (in the code editor or by ErrorChangeParameter).
WDADMINEXE: User characteristics
From the server, the "Users" tab of WDADMINEXE allows you to get......
MultiLinestring2D (Variable type)
The MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
WEBDEV concepts
FlexJustifyContent (Property)
The Property FlexJustifyContent allows you to know and modify the alignment of the fields inside the Flexbox field according to the main axis of the field ( Property corresponding CSS "justify-content").
CalendarSelectCount (Function)
Returns the number of days selected in a Calendar control.
HServerWorkingDir (Function)
Returns the path of a temporary directory on the HFSQL server.
grSunburstRootSection (Function)
Changes or specifies the path of the root in a Sunburst chart.
<Calendar>.SelectCount (Function)
Returns the number of days selected in a Calendar control.
<Chart>.SunburstRootSection (Function)
Changes or specifies the path of the root in a Sunburst chart.
Java functions
List of Java functions...
ErrorThrow (Function)
Throw a non-fatal error.
RepeatedZoneAddStart (Function)
Adds a repeat (or line) at the beginning of a field Infinite repeat zone. The repeat is inserted before the first repeat in the Repeated zone field.. The scroll position of the Repeated zone field remains unchanged.
Universal Windows 10 App applications: Required configuration
To develop Universal Windows 10 App applications with WINDEV or WINDEV Mobile, you must......
Describing a problem to the Free Technical Support
PC SOFT Free Technical Support
Thank you for buying one of our products......
Sending elements to Free Technical Support
Control template
A control template is a set of controls that can be re-used in several windows or pages......
Currencies
A currency is a real coded on 10 bytes....
Telemetry: Overview
From version 21, WINDEV proposes advanced statistics regarding the use of your WINDEV applications via the telemetry......
<Image variable>.Fill (Function)
Colors an area in an Image variable.
Help page identifier
To display a specific help page from your WINDEV application, an identifier must be specified for each page found in your help system......