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.
<Source>.BuildKeyValue (Function)
Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.).
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)....
Remote WEBDEV administrator: Managing statistics
The remote WEBDEV administrator proposes a module for consulting the statistics regarding the traffic of your dynamic WEBDEV sites (standard and AWP) and Webservices deployed on a WEBDEV Application Server....
Providing an image per DPI
On mobile, when displaying images, each device has its own physical size and its own graphic resolution......
Creating a window skin template
WINDEV Mobile: Sharing WINDEV elements
The same WINDEV elements (analysis, queries, ...) can be used in a WINDEV application and in a WINDEV Mobile application......
SchedulerListAppointment (Function)
Returns: the list of appointments found between two dates in a Scheduler control, all the appointments found in a Scheduler control, a specific appointment (selected or hovered)....
OrganizerListAppointment (Function)
Returns: the list of appointments found between two dates in an Organizer control, all appointments found in an Organizer control, a specific appointment (selected or hovered)....
<Organizer>.ListAppointment (Function)
Returns: the list of appointments found between two dates in an Organizer control, all appointments found in an Organizer control, a specific appointment (selected or hovered)....
<Scheduler>.ListAppointment (Function)
Returns: the list of appointments found between two dates in a Scheduler control, all the appointments found in a Scheduler control, a specific appointment (selected or hovered)....
The Spreadsheet control
Spreadsheets are one of the most used office tools......
xlsColumnType (Example)
Usage example of the xlsColumnType function
Page templates
WEBDEV allows you to create page templates......
Creating the Vision windows of the WINDEV RAD pattern
The "Surface" charts
The Surface chart is used to represent correlated analogical data, according to 3 axes...
Constants for managing XLS files
List of constants used by the functions for managing XLS files....
Detailed use of WINDEV FTP/RPC
WDReplic: Overview
WDReplic is a tool used to manage the replication of data between several computers that use the same application......
GanttListTask (Function)
Returns: the list of tasks between two given dates in a Gantt Chart column, all the tasks in a Gantt Chart column, a specific task (selected or hovered)....
Character strings
WLanguage supports different types of strings....
<Gantt chart>.ListTask (Function)
Returns: the list of tasks between two given dates in a Gantt Chart column, all the tasks in a Gantt Chart column, a specific task (selected or hovered)....
3. Dates, arrays and structures
WEBDEV Tutorial - WLanguage basics Lesson 3 - Dates, arrays and structures - 20 min
The structure of the RAD patterns (kept for backward compatibility)
...The RAD pattern files (MDL files) are used to describe:...
FinRepayVal (Function)
Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment.
Report based on a Scheduler control
A report based on a Scheduler control is used to directly print the information displayed in the Scheduler control......
1
…
104
105
106
107
108
…
217
>