ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
Creating an executable: Table directory
Two types of directories can be configured when creating the executable...
Table
The "Table" keyword can correspond to...
Looper control linked to a table
A Looper control can be used to display the content of a table or query...
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...
How do I run through a table?
Lists the users currently connected to one or more files handled by a Client/Server connection.
Database schema: Description of table structure
The database schema allows you to define the structure of tables used by the project...
<Source>.DescribeFile (Function)
Describes a table programmatically.
HDescribeItem (Function)
Describes a file item programmatically.
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.
HDescribeFile (Function)
Describes a table programmatically.
HNext (Function)
Sets the position on the next table record according to a browse item.
<Source>.UnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
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...
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Source>.Watch (Function)
Starts monitoring 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.
HDescribeLink (Function)
Describes a link between two tables programmatically.
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items ...
HExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
HListSemanticIndex (Function)
Returns the list of semantic indexes for a table supported by the HFSQL engine.
HUnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
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.
HListSemanticKey (Function)
Returns the list of semantic keys present in a table, query or view supported by the HFSQL engine.
<Source>.Filter (Function)
Defines and enables a filter on a table, view or query.
HListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
<Source>.Close (Function)
Closes one or all the tables opened by the current user.
<Source>.ExportXML (Function)
Exports the records from a table (HFSQL or OLE DB), view or query to an XML file.
<Source>.Next (Function)
Sets the position on the next table record according to a browse item.
HFirst (Function)
Sets the position on the first record of a table according to the specified browse item.
Zombie tables and items
During the life of an application, items live and die...
<Source>.ExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).
HPrevious (Function)
Sets the position on the previous record of the table according to a browse item.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
HLast (Function)
Sets the position on the last record of a table according to a browse item.
HDescribeFullTextIndex (Function)
Describes a full-text index of table created programmatically.
<Source>.Write (Function)
Writes a record into a table without updating the indexes corresponding to all keys used in the table.
HDBCreation (Function)
Ends the description of the structure of an xBase table programmatically.
<Source>.ListSpatialKeys (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
HListSpatialKey (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
HFilter (Function)
Defines and enables a filter on a table, view or query.
<Source>.ListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
<Source>.Last (Function)
Sets the position on the last record of a table according to a browse item.
HWrite (Function)
Writes a record into a table without updating the indexes corresponding to all keys used in the table.
<Connection variable>.ListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
<Source>.First (Function)
Sets the position on the first record of a table according to the specified browse item.
HExportXML (Function)
Exports the records from a table (HFSQL or OLE DB), view or query to an XML file.
HWatch (Function)
Starts monitoring 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.
HListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
HClose (Function)
Closes one or all the tables opened by the current user.
<Source>.Previous (Function)
Sets the position on the previous record of the table according to a browse item.
HDescribeSemanticIndex (Function)
Defines a semantic index of a table created programmatically.
1
…
3