ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

FilteredItem (Property)
The FilteredItem property is used to identify the item that has a filter implemented by HFilter.
HDeactivateFilter (Function)
Temporarily disables the filter on a table (view or query).
Filtering a table, a view or a query
A filter is used to define programmatically a selection of records corresponding to one or more criteria...
FilterWithBounds (Property)
The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL table, view or query.
<Source>.DeactivateFilter (Function)
Temporarily disables the filter on a table (view or query).
FilterCondition (Property)
The FilterCondition property gets the selection condition set by HFilter on a table, HFSQL view, or query.
HFilter (Function)
Defines and enables a filter on a table, view or query.
<Source>.Filter (Function)
Defines and enables a filter on a table, view or query.
HSimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
HRetrieveBackup (Function)
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
HRSExecute (Function)
Immediately execute periodic replication between HFSQL servers: replication is triggered ahead of schedule.
<Connection variable>.SimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data......
HExportJSONString (Function)
Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string.
HRecordToString (Function)
Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
<Connection variable>.ModifyItemRights (Function)
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table....
HListSpatialKeys (Function)
Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine.
<Source>.RecordToString (Function)
Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
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....
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword......
7. Creating HFSQL files: files physically created
The data model editor allows you to define the structure of the data files....
HTransaction (Function)
Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table.
HFSQL management functions
List of functions for HFSQL management...
HTransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table.
5. HFSQL Client/Server
A WINDEV Mobile application can also use an HFSQL database in Client/Server mode....
Transactions: Secure processes on HFSQL data files
This chapter presents the following topics......
Replication: The different types
The data replication is a powerful feature......
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......
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......
The Pivot Table control
The Pivot Table control dynamically displays data coming from the crosscheck of different files found in a database......