ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Report based on an HFSQL view
A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view...
Remote HFSQL Administrator: Overview
The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server...
<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 table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HFSQL functions (prefix syntax)
List of functions for HFSQL management
Managing the HFSQL contexts in the windows and in the reports
An HFSQL context contains information relative to the data used...
HFSQL functions
List of functions for HFSQL management
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
<Connection variable>.TransactionSavepoint (Function)
Declares a transaction savepoint.
<Source>.DescribeFile (Function)
Describes a table programmatically.
HTransactionSavepoint (Function)
Declares a transaction savepoint.
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
HTransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
HDescribeFile (Function)
Describes a table programmatically.
fDataDir (Function)
Returns the full path of the directory of HFSQL tables specified by the user when installing the application.
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.
HListItem (Function)
Returns the list of items:
HCheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
WDHFDiff: Presentation
WDHFDiff is a tool used to compare HFSQL tables...
DB2 Native Connector: Features and notes
The following paragraphs present the main aspects and specific features of the Native DB2 Connector...
Managing databases in WINDEV Java applications
This document presents the different access modes to databases from a WINDEV Java application...
Link functions
Link functions are used to link the interface with the tables and vice versa. These functions are as follows:
<Source>.CheckIndex (Function)
Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file).
<Source>.QueryExecuted (Function)
Determines if a query has been executed.
HDescribeFullTextIndex (Function)
Describes a full-text index of table created programmatically.
HExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
<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>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access...
Comparison operators
The comparison operators can be divided into several categories...
HCheckStructure (Function)
Defines the mode for comparing tables.
Filtering a table, a view or a query
A filter is used to define through programming a selection of records corresponding to one or more criteria...
<Source>.CheckMemo (Function)
Checks the structural integrity of memos in an HFSQL table.
Limitations of WINDEV, WEBDEV and WINDEV Mobile
A structure is a custom type of data...
HQueryExecuted (Function)
Determines if a query has been executed.
HCheckMemo (Function)
Checks the structural integrity of memos in an HFSQL table.
<Source>.ExportJSON (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file.
<Connection variable>.TransactionEnd (Function)
Validates the current transaction:
  • the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
File Description (Variable type)
The File Description variable is used to programmatically describe tables.
POUR TOUT / POUR ALL instruction (table browsing)
Training FOR ALL instruction can be used to perform different types of runs...
HTransactionFree (Function)
Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress.
Type of field: Secure password
"Password" items are used to securely store passwords by using a salt and a hash algorithm...
<Source>.TransactionFree (Function)
Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction.
<Source>.ExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
HTransactionInterrupted (Function)
Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled).
<Source>.ExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
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...
HTransactionEnd (Function)
Validates the current transaction:
  • the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
HExportJSON (Function)
Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file.
HCheckIndex (Function)
Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file).
<Connection variable>.TransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
Manipulating a database from a Java application
You can start developing your application as soon as the WINDEV project is defined as being a Java project...
<Source>.ExportJSONString (Function)
Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string.
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code...
HListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Source>.StatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
HExportJSONString (Function)
Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string.
HStatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
Native DB2 Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to DB2...
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
<Source>.CheckStructure (Function)
Defines the mode for comparing tables.
<Connection variable>.ModifyFileRights (Function)
Modifies the rights granted to a user or group on an HFSQL Client/Server data file....
<Organizer>.Display (Function)
Reinitializes the content of an Organizer control from its data source (HFSQL data file...
<Source>.ListKey (Function)
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
<Source>.RecordDate (Function)
Returns the date and time that an HFSQL record was last modified (Classic or Client/Server)....
<Connection variable>.ListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection....
<Connection variable>.UpdateView (Function)
... to an HFSQL server.
ActiveDirectory (Property)
The ActiveDirectory property allows you to connect to an HFSQL server using Active Directory...
HModifyFileRights (Function)
Modifies the rights granted to a user or group on an HFSQL Client/Server data file....
HListKey (Function)
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
<Connection variable>.RetrieveBackup (Function)
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
<Connection variable>.SimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
hRSConfig (Type of variable)
The hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL...
Handling data files in PHP
WEBDEV allows you to create a PHP site that handles data files......
Database parameters (Setup program)
The setup program creation wizard includes the setup of the database along with the application...
3. Data handled by a WINDEV Mobile application
The data handled by a WINDEV Mobile application can come from...
Replication: The different types
The data replication is a powerful feature......
H.TemporaryDirectory (Variable)
Allows you to force the directory used to store the temporary files when reindexing the HFSQL data...
OrgDisplay (Function)
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file...
Compression (Property)
The Compression property is used to manage data compression during a connection (HFSQL...
<Organization Chart>.Display (Function)
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file...
HRecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
<Source>.RecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
<Source>.DeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL...
<Connection variable>.InfoFileRights (Function)
Allows you to find out the rights granted to a user or to a group on an HFSQL Client/Server data...
<Connection variable>.ListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures...