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.
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>.Filter (Function)
Defines and enables a filter on a data file, view or query.
<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 ...
HEndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
<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.
RecordSize (Property)
The RecordSize property is used to get the size (in bytes) of a record in: a file described in the data model editor, a file described through programming, an HFSQL view, a query....
Report based on a memory area
A report based on a memory area is used to print the records stored in a memory area......
Libraries (.WDL file)
A library is a WDL file that contains all WINDEV or WEBDEV resources ......
How to retrieve the analysis structure through programming?
This help page explains how to retrieve the analysis structure through programming....
Report based on a query
Queries are used to easily select records in one or more data files......
Caption (Property)
In a database, the Caption property is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, the Caption property is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or page, the Caption property is also used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a Breadcrumb control....
11. Table/Looper controls
11. Table/Looper controls
What is an application?
An application is a set of objects (windows, controls, ......
1. Project and analysis
The Pager control
The Pager control is used to quickly access the records of a Table or Looper control displayed on several pages......
How to create an SQL query to get a TOP 10?
This help page presents the method for creating an SQL query used to get the first 10 records......
Manipulating controls in a page
The different operations that can be performed on the page controls are as follows......
Running a query and handling the result in WLanguage
The selection of records performed by query is not necessarily displayed in a report, in a window, ......
HFSQL Control Center: Creating and executing a query
The HFSQL Control Center allows you to create a query based on the data files of the database currently displayed in the Control Center......
Handling a dynamic programmatically
WINDEV allows you to handle Dynamic Tab controls with the TabXXX functions and with multiple WLanguage properties......
<Pivot table>.ToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
PVTToExcel (Function)
Creates an Excel file with data from a Pivot Table control.
NbMemoItem (Property)
The NbMemoItem property is used to get the total number of memo items in a record of: a file described in the data model editor, a file described through programming, an HFSQL view, a query....
Spreadsheet control in a report
The spreadsheet is one of the most often used business tools. You have the ability to create reports that print the data found in a spreadsheet....
What is a database?
A database is an organized collection of data for a particular purpose (e.g., manage orders)......
Locking data files: correspondence between WINDEV 5.5 and the later versions
The "Analysis" pane
The "Analysis" pane lists......
NbItem (Property)
The NbItem property is used to get the total number of items (including composite keys) in a record of: a file described in the data model editor, a file described programmatically, an HFSQL view, a query....
1
…
20
21
22
23
24
…
217
>