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.
Handling a Conceptual Data Model (CDM)
The main operations that can be performed on a CDM are as follows......
Compilation options (HLP format)
Native Access to SAP
SAP is a widely used ERP......
dClear (Function)
Clears the content of an Image variable or Image control and fills it with the specified color.
Android Control Center
Do you know where to find your application log files?...
1. What is a website?
Background tasks
Continuing to run a process when the application is in background is very useful on mobile......
<Table>.DisableFilter (Function)
Disables a user filter on a column or on all the columns found in a Table or TreeView Table control.
Code history
The code history is used to......
<gglConnection variable>.FillCalendarByRequest (Function)
Fills a calendar that was retrieved beforehand: the events corresponding to the calendar are retrieved from a custom request.
WINDEV FTP functions
List of WINDEV FTP functions...
Filter (Function)
Returns an array containing the elements of a source array for which a procedure returns True.
Help: Summary table
In a WINDEV application, users have multiple help features at their disposal: Tooltip. Status bar. Help window. Advanced tooltip. Help page. HLP file....
Importing/Consuming web services
WINDEV, WEBDEV and WINDEV Mobile allow you to directly import Webservices into your applications......
zipFilter (Function)
Returns the list of archive formats supported by the current platform, in the format expected by the filter of fSelect.
fGraphicFilter (Function)
Returns the list of image formats supported by the current platform, in the format expected by the filter of fSelect.
<gglConnection variable>.FillCalendar (Function)
Fills a calendar that was retrieved beforehand: the events corresponding to the calendar are retrieved (some criteria may be specified).
How to include secure payment in a WEBDEV site?
This help page explains how to add a secure payment into a WEBDEV site......
Start of Document block
The Start of document block is printed once at the beginning of the report execution......
Window with parameters
A window can: Receive parameters when it is opened. Return values when it is closed....
Creating the summary
Users are familiar with summaries, as the summary is the first element they look at in printed documentation......
Project configuration
Project configurations allow you to adapt the same project to multiple "targets"......
3. Dates, arrays and structures
WINDEV Tutorial: WLanguage basics Lesson 3 - Dates, arrays and structures - 20 min
MongoDB/GRIDFS databases
MongoDB is a document-oriented NoSQL database......
Report viewer: Text copy
The report viewer allows you to copy text from the report and paste it to a file in another application......
1
…
103
104
105
106
107
…
217
>