ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFilter (Function)
Defines and enables a filter on a table, view or query.
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.
<Source>.Filter (Function)
Defines and enables a filter on a table, view or query.
FilteredItem (Property)
The FilteredItem property is used to identify the item that has a filter implemented by HFilter.
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data......
<Connection variable>.ListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
HListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
Compression (Property)
The Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.)...
HListAnalysis (Function)
Returns the list of WINDEV or WEBDEV analyses (in HFSQL Classic format) available in a given directory.
Encryption (Property)
The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server.
<Connection variable>.TransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
<Connection variable>.Transaction (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
HFSQL properties
List of HFSQL properties...
mongoOperationDeleteAll (Type of variable)
The mongoOperationDeleteAll type is used to define all the advanced characteristics of a document delete operation that will be added to a bulk operations list. All the documents that match the selection filter will be deleted.
mongoOperationUpdateAll (Type of variable)
The mongoOperationUpdateAll type is used to define all the advanced characteristics of a document update operation that will be added to a bulk operations list. All the documents that match the selection filter will be updated.
mongoOperationReplaceOne (Type of variable)
The mongoOperationReplaceOne type is used to define all the advanced characteristics of a document replace operation that will be added to a bulk operations list. The first document that matches the filter will be replaced.
Examples for using the OLE DB provider for HFSQL
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file for example)....
HFSQL Client/Server management functions
Several HFSQL functions are used to manage the HFSQL Client/Server data......
HSortView (Function)
Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism.
mongoOperationDeleteOne (Type of variable)
The mongoOperationDeleteOne type is used to define all the advanced characteristics of a document delete operation that will be added to a bulk operations list. The first document that matches the filter will be deleted.