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.
HDeleteAll (Function)
Deletes all records from a table, an HFSQL view or a query.
<Source>.ReadLast (Function)
Sets the position on the last record of a table according to a browse item.
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).
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>.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.
<Connection variable>.DeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server tables....
HDeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server tables....
HSuggestKey (Function)
Returns a list of keys to add to tables to improve query performance.
NullSupported (Property)
The NullSupported property is used to manage the NULL value in HFSQL tables.
HRplDeclareLink (Function)
Declares a (1, 1) (0, n) link between two tables.
The indexed controls
A control is an indexed control if it contains several controls with the same name......
AAFExportSecurity (Function)
Secures the export of confidential data in the AAFs (Automatic Application Features) that are used...
Multiline (Property)
option of an Edit control. find out and modify the "Multiline" option of a column in a Table control....
CurrentIndex (Function)
in the current Table control, the number of the option with focus in a Check Box control, the number...
StoredValue (Property)
ListView or Combo Box control. a "Text token" Edit control. a row of a Table control. an input...
HTransactionEnd (Function)
Validates the current transaction: the modifications performed on the table since the start...
MaxValue (Property)
The MaxValue property is used to: get and set the top value of a report based on a table. get...
MinValue (Property)
The MinValue property is used to: get and set the bottom value of a report based on a table....
<Connection variable>.TransactionEnd (Function)
Validates the current transaction: the modifications performed on the table since the start...
Context menu of TreeView controls (AAF)
Each TreeView control found in a window proposes a popup menu to the user......
Converting an HFSQL Classic database into HFSQL Client/Server
There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV...
Remote WEBDEV administrator: Connection management
The remote administration tool is used to manage the connections to the dynamic WEBDEV websites....
HCheckIndexAsynchronous (Function)
contained in the HFSQL Client/Server table (.FIC file). This new function is available from WINDEV Suite...
<Connexion HFSQL>CheckAsynchronousIndex (Function)
contained in the HFSQL Client/Server table (.FIC file). This new function is available from WINDEV Suite...
Error 104: 'Dynamic' can only be used for the classes and the Automation objects
NullAllowed (Property)
The NullAllowed property is used to manage the NULL value in the items of HFSQL tables.
<Connection variable>.ListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection....
1
…
50
51
52
53
54
…
131
>