ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
The Table control
The Table allows users to easily view and enter data stored in memory or from a table, view or query...
Generating a description of a table from a window or from a page
When you design a quick prototype, you often create windows (or pages) without defining any tables...
Database schema: Description of table structure
The database schema allows you to define the structure of tables used by the project...
Linking a data-bound Table control to a table or query
A Table control can be used to display the content of a table or query...
Table
The "Table" keyword can correspond to...
Creating an executable: Table directory
Two types of directories can be configured when creating the executable...
Looper control linked to a table
A Looper control can be used to display the content of a table or query...
How do I run through a table?
Lists the users currently connected to one or more files handled by a Client/Server connection.
The Table control on mobile devices (Android and iOS)
The Table control is available for Android and iOS applications...
HLast (Function)
Sets the position on the last record of a table according to a browse item.
<Source>.Filter (Function)
Defines and enables a filter on a table, view or query.
<Source>.NoModif (Function)
Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy).
<Source>.Watch (Function)
Trigger monitoring of write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered.
HDescribeFullTextIndex (Function)
Describes a full-text index of table created programmatically.
HDeactivateFilter (Function)
Temporarily disables the filter on a table (view or query).
<Source>.SavePosition (Function)
Stores the current context of a table: current record, filter, read pointers.
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
HDescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL table.
HWatch (Function)
Trigger monitoring of write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered.
HReadNext (Function)
Sets the position on the next table record according to a browse item.
<Source>.Next (Function)
Sets the position on the next table record according to a browse item.
HReadLast (Function)
Sets the position on the last record of a table according to a browse item.
HCancelAlias (Function)
Cancels an alias that was declared beforehand by HAlias.
HFirst (Function)
Sets the position on the first record of a table according to the specified browse item.
HListLink (Function)
Returns the list of table bindings (Merise type) present:
  • in the current database schema,
  • in ongoing database schemas (projects with multiple database schemas).
  • in a specific database schema.
<Source>.DescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL table.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
HRestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
HDescribeSemanticIndex (Function)
Defines a semantic index of a table created programmatically.
<Source>.FTListWord (Function)
Lists the words of the current record that will be taken into account by the full-text indexing.
HEndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
<Source>.Previous (Function)
Sets the position on the previous record of the table according to a browse item.
HDeactivateTrigger (Function)
Disables a trigger.
HClose (Function)
Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user.
HSetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
HOpen (Function)
Opens a table.
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 table.
HExportJSON (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file.
<Source>.Delete (Function)
Deletes a record from a table (query or view).
HListREP (Function)
Returns the list of assignments for the tables handled by the current application, which means the list of physical files corresponding to the files described in the database schema.
HErrorPassword (Function)
After the execution of a read or write function in a table, used to find out whether an error caused by a wrong password occurred on this table.
HListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
HDescribeFile (Function)
Describes a table programmatically.
<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).
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HListSynonym (Function)
Returns the list of synonyms used by a full-text index.
HListStopWord (Function)
Returns the list of stop words used by a full-text index.
HWrite (Function)
Writes a record into a table without updating the indexes corresponding to all keys used in the table.
<Source>.EndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
<Source>.ExportCSV (Function)
Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file.
<Source>.ReadNext (Function)
Sets the position on the next table record according to a browse item.
<Source>.ListItem (Function)
Returns the list of items in a table (query or view) recognized by the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
<Source>.Close (Function)
Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user.
<Source>.SetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
fDataDir (Function)
Returns the full path of the directory of HFSQL tables specified by the user when installing the application.
<Source>.GetCurrentPosition (Function)
Returns the approximate position of current record in the table.
<Source>.Read (Function)
Reads a record in a file according to a given record number.
<Source>.Out (Function)
Allows you to find out whether the record on which you want to be positioned is located outside the table, filter, view or query.
<Source>.DeactivateFilter (Function)
Temporarily disables the filter on a table (view or query).
<Source>.Found (Function)
Checks whether the current record corresponds to the current filter or search.
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
<Source>.DeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
<Source>.ListLink (Function)
Returns the list of links (Merise) in the current database schema or in a specific database schema.
HCheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
<Source>.RetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HSavePosition (Function)
Stores the current file context (current record, filter, pointers).
HRead (Function)
Reads a record in a file according to a given record number.
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile support NULL values in items of HFSQL tables and for all other types of access (Native, OLE DB...
HErrorLock (Function)
Used to check whether a lock error occurred.
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
HRecordToString (Function)
Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items ...
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Source>.ReadLast (Function)
Sets the position on the last record of a table according to a browse item.
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).
HExportXML (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to an XML file.
HDescribeItem (Function)
Describes a file item programmatically.
<Source>.First (Function)
Sets the position on the first record of a table according to the specified browse item.
HNext (Function)
Sets the position on the next table record according to a browse item.
<Source>.ExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
<Source>.ExportJSON (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file.
<Source>.DescribeFile (Function)
Describes a table programmatically.
HDescribeLink (Function)
Describes a link between two tables programmatically.
HExportCSV (Function)
Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file.
HWatchStop (Function)
Stops watching a table on an HFSQL server.
<Source>.Write (Function)
Writes a record into a table without updating the indexes corresponding to all keys used in the table.
HNoModif (Function)
Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy).
HDeleteAll (Function)
Deletes all records from a table, an HFSQL view or a query.
<Source>.RestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
HListSpatialKey (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
HPrevious (Function)
Sets the position on the previous record of the table according to a browse item.
HOut (Function)
Used to find out whether the record on which you want to be positioned is located outside the table, filter, view or query.
<Source>.ListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
HUnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
HExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
Zombie tables and items
During the life of an application, items live and die...
HCreateView (Function)
Creates an HFSQL view.
This function uses the former view mechanism.
<Source>.UnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
<Source>.ExportXML (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to an XML file.
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Source>.Open (Function)
Opens a table.
HListItem (Function)
Returns the list of items:
HDelete (Function)
Deletes a record from a table (query or view).
HListFile (Function)
Returns the list of files:
  • current database schema.
  • database schemas in progress (projects with multiple database schemas).
  • a specific database schema 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>.ListSynonym (Function)
Returns the list of synonyms used by a full-text index.
HDBCreation (Function)
Ends the description of the structure of an xBase table programmatically.
<Source>.DeleteAll (Function)
Deletes all records from a table, an HFSQL view or a query.
<Source>.WatchStop (Function)
Stops watching a table on an HFSQL server.
HGetCurrentPosition (Function)
Returns the approximate position of current record in the table.
Managing connections
WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection...
<Source>.Last (Function)
Sets the position on the last record of a table according to a browse item.
<Connection variable>.ListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
<Source>.ListSpatialKeys (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
<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.
HListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
HDeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
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.
<Source>.RecordToString (Function)
Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
HFilter (Function)
Defines and enables a filter on a table, view or query.
HReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
HFound (Function)
Checks whether the current record corresponds to the current filter or search.
<Source>.ExportJSONString (Function)
Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string.
HExportJSONString (Function)
Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string.
<Source>.ReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
HFTListWord (Function)
Lists the words of the current record that will be taken into account by the full-text indexing.
<Source>.CreateView (Function)
Creates an HFSQL view.
This function uses the former view mechanism.
HRetrieveItem (Function)
Returns the content of an item found in the current record (in the table, view, query, ...).
TableFormulaAdd (Function)
Adds a calculated row to a Table control by providing custom calculation procedures.
hbWrite (Function)
Writes cells (values of items) to one or more rows (records) in an HBase table.
TableListChild (Function)
Lists the "children" of a node and the "child" elements of these "children" in a TreeView Table...
TableRecNum (Function)
Returns the number of the current record in a Table control based on a data file.
TableItemStatus (Function)
Returns the status of a node in a Treeview Table control: collapsed, expanded or not found.
HInfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server table....
<Source>.RetrieveItem (Function)
Returns the content of an item found in the current record (in the table, view, query, ...).
Memory (Property)
... on a table.
<Scheduler>.Display (Function)
Reinitializes the content of a Scheduler control from its data source (HFSQL table, for example).
Break management functions
The following functions are used to manage loopers in the Table controls and the Looper controls:...
Item Description (Variable type)
An Item Description variable is used to describe one or more items in a table programmatically.
<Source>.ChangeDir (Function)
Changes the path to a table (i.e. directory in which the file will be handled).
GetColor (Function)
Allows you to get a set of harmonious colors without having to use a table of colors.
PVTCalculateAllAsynchronous (Function)
Entirely calculates or recalculates a Pivot Table control, without blocking the application.
ListDisplay (Function)
Refreshes a List Box, ListView or Combo Box control based on a table
SchedulerDisplay (Function)
Reinitializes the content of a Scheduler control from its data source (HFSQL table, for example).
Alias type
The Alias type is used to declare and handle a logical alias for a table or query.
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the table (query or view).
PVTSave (Function)
Saves the result of the calculation performed in a Pivot Table control (in a file or in memory).
HModify (Function)
Modifies the specified record or the record found in memory in the table (query or view).
1
…
35
36
37
38
39
…
131
>