ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
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...
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...
Table
The "Table" keyword can correspond to...
The Table control
The Table allows users to easily view and enter data stored in memory or from a table, view or query...
Database schema: Description of table structure
The database schema allows you to define the structure of tables used by the project...
Creating an executable: Table directory
Two types of directories can be configured when creating the executable...
The Table control on mobile devices (Android and iOS)
The Table control is available for Android and iOS applications...
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.
HDescribeFullTextIndex (Function)
Describes a full-text index of table created programmatically.
<Source>.Filter (Function)
Defines and enables a filter on a table, view or query.
HLast (Function)
Sets the position on the last record of a table according to a browse item.
<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.
<Source>.NoModif (Function)
Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy).
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Source>.SavePosition (Function)
Stores the current context of a table: current record, filter, read pointers.
HDeactivateFilter (Function)
Temporarily disables the filter on a table (view or query).
HReadNext (Function)
Sets the position on the next table record according to a browse item.
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.
HExportJSON (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file.
<Source>.Next (Function)
Sets the position on the next table record 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.
HEndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
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.
<Source>.DescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL table.
HOpen (Function)
Opens a table.
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.
<Source>.DeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
HReadLast (Function)
Sets the position on the last record of a table according to a browse item.
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items ...
<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.
HExportXML (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to an XML file.
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.
HDescribeFile (Function)
Describes a table programmatically.
<Source>.DescribeFile (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).
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).
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.
<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.).
HListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
HDeleteAll (Function)
Deletes all records from a table, an HFSQL view or a query.
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).
<Source>.ReadLast (Function)
Sets the position on the last record of a table according to a browse item.
<Source>.Previous (Function)
Sets the position on the previous record of the table according to a browse item.
<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.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
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).
HDescribeItem (Function)
Describes a file item programmatically.
<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.
Table,Select,+ (External language)
Selects an element in a Table control.
Table,Display (External language)
Refreshes the Table control.
Table,Add (External language)
Adds an element to a Table control.
Table,Search (External language)
Searches for a value in a Table control populated programmatically.
Table,Col (External language)
Returns the current index of the column.
Table,Save (External language)
Updates or adds a record in the data file linked to the Table control.
Table,Insert (External language)
Inserts an element into a table at a given position.
Table,Modify (External language)
Modifies an element in a Table control.
Table,Count (External language)
Returns the number of elements in a Table control.
Table,Position (External language)
Sets the position on a given element or returns the element on the fist row of a Table control...
Table,Get (External language)
Retrieves the value of a given element or the value of the selected element in a table.
Table,Select,? (External language)
Returns the index of the selected element in a Table control.
TreeView Table control functions
List of functions for managing TreeView Table controls...
Table,Delete (External language)
Deletes an element from a Table control.
Printing the content of a table (AAF)
A Table control proposes an automatic popup menu allowing the user to perform several operations...
Creating a Pivot Table control
To create a Pivot Table control......
Description of a Pivot Table control
The description window of a Pivot Table control is used to configure several elements...
Pivot Table control functions
Pivot Table control functions...
Infinite Table and Looper controls
There are two methods to populate Table and Looper controls programmatically......
Pivot Table control in a report
The report editor allows you to create "Crosstab" reports......
AAF: Chart on a table column
When a table column is a Numeric column, the end user can create a chart on the column data...
Characteristics of Table controls in a page
Table controls allow you to display and/or enter data......
How to fill a TreeView Table control?
This help page explains how to populate a TreeView Table control programmatically....
How to populate a Table control programmatically?
This help page presents the different methods that can be used to populate a Table control...
11. Table/Looper controls
1
…
6
7
8
9
10
…
131
>