ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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).
fSaveBuffer (Function)
Creates and fills a text file with the content of a string or buffer variable.
The "Line" charts
In the line charts, the data is interpreted as successive y coordinates of points......
Managing the automatic identifiers when adding a record
When adding a record into a HyperFileSQL file (HAdd), three management modes are available for the automatic identifiers......
Result of a query in test mode
After its execution in test mode (see Running the query test), the result of the query can be......
How to create an SQL query to get a sum?
This help page explains how to create a Sum query with the query editor....
PVTCalculateUpdate (Function)
Updates some of the data found in a Pivot Table control from a given date.
<Pivot table>.CalculateUpdate (Function)
Updates some of the data found in a Pivot Table control from a given date.
Caption (Property)
In a database, the Caption property is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, the Caption property is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or page, the Caption property is also used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a Breadcrumb control....
HFSQL Client/Server: Principle for saving the databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis......
How to create an SQL query to count?
This help page explains how to create a count query with the query editor....
Custom synchronization for Table controls based on a data file
In some cases, you may want to use a custom synchronization for Table controls based on a data file......
WDInst: configuring the characteristics of the files to install
WDInst allows you to configure the characteristics of the files to install......
Native Sybase Connector: Programming with HFSQL functions
To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis......
Native Informix Connector: Programming with HFSQL functions
To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis......
HRestorePosition (Function)
Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
Creating a translation file
WDINT allows you to create a translation file....
Charset (Property)
The Charset property is used to: Get the character set used by a Font variable. Change the character set used by a Font variable. Get the character set used by an HFSQL data file....
Thumbnail (Property)
The Thumbnail property can be used on: the items of an HFSQL data file. For more details, see Thumbnail property on items. the Thumbnail controls (WEBDEV only). For more details, see Thumbnail property on Thumbnail controls....
Creating a combining query
A combining query (corresponding SQL statement: UNION) ......
<Page>.FromFile (Function)
Automatically updates the controls of a page with: the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible). the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible)....
FileToPage (Function)
Automatically updates the controls of a page with: the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible). the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible)....
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ......
How to loop through the files of a directory?
This help page presents the different methods that can be used to loop through the files of a directory....
<Source>.RestorePosition (Function)
Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
Server triggers
Server triggers are stored procedures executed by the server before or after a write operation performed on a database file......