ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Database schema: Description of table structure
The database schema allows you to define the structure of tables used by the project...
Looper control linked to a table
A Looper control can be used to display the content of a table or query...
Creating an executable: Table directory
Two types of directories can be configured when creating the executable...
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.
Table
The "Table" keyword can correspond to...
HDescribeItem (Function)
Describes a file item programmatically.
HDescribeLink (Function)
Describes a link between two tables 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.
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>.UnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
HDescribeFile (Function)
Describes a table programmatically.
<Source>.DescribeFile (Function)
Describes a table programmatically.
HListSpatialKey (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
HDescribeSemanticIndex (Function)
Describes a semantic index of a programmatically created table.
Zombie tables and items
During the life of an application, items live and die...
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
HDescribeFullTextIndex (Function)
Describes a full-text index of table created programmatically.
HListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
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.
<Source>.ListKey (Function)
Returns the list of keys in a table (query or view) recognized by the HFSQL engine.
<Connection variable>.ListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items ...
HListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
HUnlockFile (Function)
Unlocks the records of a table:
  • locked by HLockFile.
  • individually locked by a locking read function.
1
2