ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Connection variable>.ModifyFileRights (Function)
Sets the rights granted to a user or group on an HFSQL Client/Server data file.
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HCheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HModifyFileRights (Function)
Sets the rights granted to a user or group on an HFSQL Client/Server data file.
<HFSQL connection>.CheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<HFSQL connection>.StatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
HInfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server data file.
<Connection variable>.InfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server data file.
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
TableEnd (Function)
Stops the manual iteration of data file linked to a Table control based on a data file.
<Table>.End (Function)
Stops the manual iteration of data file linked to a Table control based on a data file.
Managing HFSQL Classic data files
The HFSQL Control Center allows you to fully manage HFSQL Classic data files......
PersistedCalculatedItem (Property)
The PersistedCalculatedItem property is used to: Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or through programming. Define whether the value of a calculated item is stored in the data file (when describing the item through programming)....
1. Analysis: Database structure
When a WINDEV, WEBDEV or WINDEV Mobile project uses data files, it must be associated with an analysis....
Replication (Property)
The Replication property is used to: determine the replication mode used for a data file (defined in the data model editor or programmatically). specify the replication mode used for a data file (file described programmatically only)....
Native Informix Connector: Programming with SQL functions
The use of SQL functions to manipulate Informix data does not require importing the file structure into the analysis......
Native Sybase Connector: Programming with SQL functions
The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis......
HFSQL Client/Server: Configuring the server
HCheckMemo (Function)
Checks the structural integrity of memos in an HFSQL data file.
HListItem (Function)
Returns the list of items: found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. found in a Record variable....
HDuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
Unalterable (Property)
The Unalterable property is used to configure the unalterability of a data file: the data file cannot be modified; only additions can be made.
<Looper>.ToXML (Function)
Creates an XML file with data from a Looper control (Looper control based on a data file or populated programmatically).
<Source>.DuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
Error 404: The file for HFSQL browse cannot be an expression of this type
GenerationNumber (Property)
The GenerationNumber property is used to get the generation number of the physical data file associated with the logical data file.
LooperToXML (Function)
Creates an XML file with data from a Looper control (Looper control based on a data file or populated programmatically).
Abbreviation (Property)
The Abbreviation property gets the abbreviation of a data file. This abbreviation is defined in the data model editor when defining the data file. This property is read-only.
<Connection variable>.Backup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
How to create an SQL query with a calculation formula?
This help page explains how to create a query with a calculation formula with the query editor....
HBackup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
MinValue (Property)
The MinValue property is used to: get and set the bottom value of a report based on a data file. get the minimum value of the current filter. get the minimum value of a data series in a chart. get and set the minimum value for some types of controls....
MaxValue (Property)
The MaxValue property is used to: get and set the top value of a report based on a data file. get the maximum value of the current filter. get the maximum value of a data series in a chart. get and set the maximum value for some types of controls....
Content of the Table control
A Table control can be based on a data file, based on a variable or populated programmatically......