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>.Count (Function)
Returns: the number of columns found in a Table or TreeView Table control. the number of rows...
<Table>.InputInProgress (Function)
Indicates whether or not a Table or TreeView Table control is in edit mode.
<Table>.AddTitleHeader (Function)
Adds a column title-header into a Table or TreeView Table control in a window.
Content of the Table control
Table controls can be bound to a table, to a variable, or be populated programmatically......
<Table>.Add (Function)
Adds a row in: a Table control, a TreeView Table control, a Combo Box control "with table"...
The TreeView Table control
The Treeview Table control is a cross between the Table control and the TreeView control......
<Table>.StartFilling (Function)
Starts the process to populate a Table or TreeView Table control programmatically.
<Table>.Display (Function)
Refreshes a Table or TeeeView Table control from a given position: for a field linked...
<Table>.AddLine (Function)
Adds a row in: a Table control, a TreeView Table control....
<Table>.SelectToFile (Function)
Positions on the table record corresponding to a row selected in the multi-selection data-bound...
<Table>.InsertColumn (Function)
Inserts elements in the format of columns into a horizontal Table control.
<Table>.Delete (Function)
Deletes a row from: a Table control, a TreeView Table control, a table displayed in a Combo...
How do I run a table with a filter?
How to discover WINDEV Mobile?...
<Table>.Save (Function)
Updates or adds the record bound to the current row in the Table or TreeView Table control.
<Table>.DeleteAll (Function)
Deletes all rows from: a Table control populated programmatically, a TreeView Table control...
<Table>.MoveColumn (Function)
Moves a column in a Table or TreeView Table control.
<Table>.FormulaDeleteAll (Function)
Deletes all rows added with <Table>.FormulaAdd.
<Table>.EnumColumn (Function)
Returns the name of a column found in a Table or Treeview Table control.
Automatic table modification
The automatic table modification updates the description of tables on user computers......
<Table>.ToExcel (Function)
Creates an Excel file with the data from a Table or TreeView Table control.
<Table>.ModifyLine (Function)
Modifies a row in: a Table control, a TreeView Table control....
<Table>.ToXML (Function)
Creates an XML file from the data found in a Table or TreeView Table control.
<Table>.DeleteSelect (Function)
Deletes the selected rows from a Table or Treeview Table control.
Programming the table cells
The Table controls can be handled......
<Table>.CellSelect (Function)
Returns the coordinates (row number and column number) of a selected cell. This function is kept...
1
…
3
4
5
6
7
…
131
>