HFSQL views An HFSQL view corresponds to a "memory image" of an HFSQL data file... Operating mode of HFSQL application An HFSQL application can operate in network mode or in Client/Server mode... Using Unicode in HFSQL data files The analysis proposes two types of Unicode items... HFSQL Client/Server functions Several HFSQL functions are used to manage the HFSQL Client/Server data... Managing spatial data in HFSQL databases Starting with version 2024, you can store and manipulate geometric and geographic data in HFSQL databases... HFSQL error handling help WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors... HFSQL Client/Server functions (prefix syntax) Several HFSQL functions are used to manage the HFSQL Client/Server data... HFSQL Client/Server: Overview You have the ability to create applications that access the HFSQL Client/Server databases... <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. HFSQL functions (prefix syntax) List of functions for HFSQL management Browsing the HFSQL data files The "Key" items are used to organize the records in a data file in order to optimize the browse or the search... HFSQL functions List of functions for HFSQL management Converting an HFSQL Classic database into HFSQL Client/Server There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV and WINDEV Mobile... <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. ODBC driver for HFSQL Classic and for HFSQL Client/Server (Windows) The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... ODBC driver for HFSQL Classic and for HFSQL Client/Server (Linux) The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... Stored procedures and queries (HFSQL Client/Server) The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... <Source>.StatDate (Function) Returns the date of the last update for the index statistics. <Source>.Filter (Function) Defines and enables a filter on a data file, view or query. HSetLog (Function) Enables or disables log management on a file. HFreePosition (Function) Deletes a position saved by HSavePosition. 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. <Connection variable>.TransactionEnd (Function) Validates the current transaction: the modifications performed on the data file 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. <Connection variable>.Transaction (Function) Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. <Source>.ExportXML (Function) Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. <Source>.ExportCSV (Function) Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. 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... SQL commands available in an SQL query WINDEV allows you to easily run queries in SQL code... HErrorLock (Function) Used to check whether a lock error occurred. HCheckMemo (Function) Checks the structural integrity of memos in an HFSQL data file. <Source>.DescribeFile (Function) Describes a data file programmatically. HDescribeFullTextIndex (Function) Describes a full-text index of data file created programmatically. <Source>.SetTransaction (Function) Enables or disables the management of transactions for one or more files. HRestorePosition (Function) Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. HExportJSONString (Function) Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. <Source>.RecordToString (Function) Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). HExportXML (Function) Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. HImportText (Function) Imports a Text file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). HExportCSV (Function) Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. HEndNoModif (Function) Unlocks a file that was locked by the same program with HNoModif. HDescribeFile (Function) Describes a data file programmatically. HListSpatialKeys (Function) Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. HClose (Function) Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. Link Description (Variable type) A Link Description variable is used to describe a link between two data files programmatically. <Source>.ImportXLS (Function) Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). HLogStop (Function) Stops the log process of a file. HOnError (Function) Customizes the management of HFSQL errors. HNoModif (Function) Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). HSecurity (Function) Enables or disables the automatic security mechanism on one or more data files. <Source>.DeleteAll (Function) Deletes all records from a data file, an HFSQL view or a query. <Source>.ImportText (Function) Imports a Text file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). HSetTransaction (Function) Enables or disables the management of transactions for one or more files. HDelete (Function) Deletes a record from a data file (query or view). <Source>.Previous (Function) Sets the position on the previous record of the data file according to a browse item. <Source>.LogStop (Function) Stops the log process of a file. HSavePosition (Function) Stores the current file context (current record, filter, pointers). HRecordToString (Function) Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). <Source>.ErrorStatusModification (Function) Returns the status of a record during a modification conflict. <Source>.CheckStructure (Function) Defines the mode for comparing data files. HTransactionInProgress (Function) Used to find out whether a transaction is in progress. HGetCurrentPosition (Function) Returns the approximate position of current record in the data file. WDHFDiff: Presentation WDHFDiff is a tool used to compare HFSQL data files... HSeekFirst (Function) Positions on the first file record whose value for a specific item is greater than or equal to a sought value. <Source>.Delete (Function) Deletes a record from a data file (query or view). HFTListWord (Function) Lists the words of the current record that will be taken into account by the full-text indexing. <Source>.GetCurrentPosition (Function) Returns the approximate position of current record in the data file. HErrorModification (Function) Allows you to: return the value of a record item if a modification conflict occurs. check if a modification conflict occurred. <Source>.NoModif (Function) Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). <Source>.ExportXLS (Function) Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). HStatDate (Function) Returns the date of the last update for the index statistics. Limitations of WINDEV, WEBDEV and WINDEV Mobile <Source>.Optimize (Function) Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. REP files REP files contain the list of data files handled by the application. HReadSeek (Function) Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). <Source>.CreateView (Function) Creates an HFSQL view. This function uses the former view mechanism. <Source>.Last (Function) Sets the position on the last record of a data file according to a browse item. <Source>.FTListWord (Function) Lists the words of the current record that will be taken into account by the full-text indexing. HExecuteQuery (Function) Declares a query created in the query editor to the HFSQL engine and runs this query. HFirst (Function) Sets the position on the first record of a data file according to the specified browse item. <Source>.SeekFirst (Function) Positions on the first file record whose value for a specific item is greater than or equal to a sought value. HImportXLS (Function) Imports an XLS file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). HErrorDuplicates (Function) Used to check whether a duplicate error occurred. <Source>.ExportJSONString (Function) Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. The log process A log is a special file that contains the history of all changes made to one or more data files over a given period of time (date the file was created, last automatic data modification, last backup created with WDLog, etc.) <Source>.SetPosition (Function) Sets the position on a record, based on the approximate position of one of its items. HDeactivateTrigger (Function) Disables a trigger. HCloseAnalysis (Function) Closes the current analysis (or all current analyses in the case of a project with multiple analyses). <Source>.TransactionFree (Function) Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. <Source>.OnError (Function) Customizes the management of HFSQL errors. HSetMemo (Function) Used to modify the management mode of memo items. HReindexingInProgress (Function) Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. <Source>.RestorePosition (Function) Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. <Connection variable>.SetIntegrity (Function) Enables or disables the management of an integrity constraint on a file link. <Source>.ListSynonym (Function) Returns the list of synonyms used by a full-text index. HReset (Function) Initializes: one or all variables of file items with their default values. one or all items of a Record variable with their default values. <Source>.ListItem (Function) Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. <Source>.ReadSeek (Function) Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). HStatTime (Function) Returns the time of the last update for the index statistics. <Source>.Write (Function) Writes a record into a data file without updating the indexes corresponding to all keys used in the file. <Source>.Close (Function) Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. HOut (Function) Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. <Source>.SavePosition (Function) Stores the current context of a data file: current record, filter, read pointers. HExportJSON (Function) Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. HSeekLast (Function) Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. <Source>.Security (Function) Enables or disables the automatic security mechanism on one or more data files. <Source>.ReadNext (Function) Sets the position on the next data file record according to a browse item. HCheckIndex (Function) Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). HStatNbRecRange (Function) Returns an estimate regarding the number of entries for a given key item in a given interval of values. HSetDuplicates (Function) Enables or disables the management of duplicates on a unique key. Composite keys A composite key is a key item containing several other items... HDescribeItem (Function) Describes a file item programmatically. <Source>.LogRestart (Function) Restarts the logging process on a file. HErrorPassword (Function) After the execution of a read or write function in a data file, used to find out whether an error caused by a wrong password occurred on this data file. HDeleteAll (Function) Deletes all records from a data file, an HFSQL view or a query. <Source>.SetLog (Function) Enables or disables log management on a file. HRecreateSubscriberReplica (Function) Recreates the subscriber replica description file (universal replication only) based on the information of the master replica (.rpm and .syn files). <Source>.Next (Function) Sets the position on the next data file record according to a browse item. HListLink (Function) Returns the list of data file bindings (Merise type) present: in the current analysis, in ongoing analyses (projects with multiple analyses). in a specific analysis. HReadNext (Function) Sets the position on the next data file record according to a browse item. <Source>.StatNbRecRange (Function) Returns an estimate regarding the number of entries for a given key item in a given interval of values. <Source>.ListLink (Function) Returns the list of links (Merise) in the current analysis or in a specific analysis. HFilter (Function) Defines and enables a filter on a data file, view or query. <Source>.ListFullTextIndex (Function) Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. <Source>.ExecuteQuery (Function) Declares a query created in the query editor to the HFSQL engine and runs this query. HSetTrigger (Function) Enables or disables the management of triggers. <Source>.SeekLast (Function) Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. 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... HTransactionInterrupted (Function) Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled). <Source>.EndNoModif (Function) Unlocks a file that was locked by the same program with HNoModif. HCross (Function) Crosses a record in a data file. HErrorIntegrity (Function) Used to check whether an integrity error occurred. HImportCSV (Function) Imports a CSV file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). Link functions (prefix syntax) Link functions are used to link the interface with the data files and vice versa. <Source>.SetDuplicates (Function) Enables or disables the management of duplicates on a unique key. HCreateView (Function) Creates an HFSQL view. This function uses the former view mechanism. HBackward (Function) Moves backward several records from the current position in the data file, according to a specified item. Managing databases in WINDEV Java applications This document presents the different access modes to databases from a WINDEV Java application... <Source>.ErrorModification (Function) Returns the value of a record item when a modification conflict occurs.. <Source>.DescribeTrigger (Function) Adds or modifies a trigger on an HFSQL 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. HListAnalysis (Function) Returns the list of WINDEV or WEBDEV analyses (in HFSQL Classic format) available in a given directory. Aliases on data files: HAlias function The aliases are used to handle... <Source>.CheckIndex (Function) Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). <Source>.ExportJSON (Function) Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. HOptimize (Function) Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. <Source>.RetrieveRecord (Function) Returns the content of the current record (in a file, a view or a query, ...). HLogRestart (Function) Restarts the logging process on a file. HCreateMasterReplica (Function) Creates the description file of a Master Replica (logged replication or universal replication). HRetrieveRecord (Function) Returns the content of the current record (in a file, a view or a query, ...). HTransactionRollbackToSavepoint (Function) Rolls the transaction back to the savepoint. <Source>.Cross (Function) Crosses a record in a data file. <Source>.ReadPrevious (Function) Sets the position on the previous record of a file according to a browse item. HDeactivateFilter (Function) Temporarily disables the filter on a data file (view or query). Database access: summary WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... <Source>.Out (Function) Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. HTransaction (Function) Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. Type of field: Secure password "Password" items are used to securely store passwords by using a salt and a hash algorithm... Alias type The Alias type is used to declare and handle a logical alias for a data file or query. HSetPosition (Function) Sets the position on a record, based on the approximate position of one of its items. HSeek (Function) Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). HFound (Function) Checks whether the current record corresponds to the current filter or search. <Connection variable>.TransactionRollbackToSavepoint (Function) Rolls the transaction back to the savepoint. HStatNbDuplicates (Function) Returns the number of duplicates for a given key item. HTransactionFree (Function) Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress. Spare server A "spare" server is a target server in a unidirectional automatic replication... HTransactionEnd (Function) Validates the current transaction: the modifications performed on the data file 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 data files. <Source>.StatNbDuplicates (Function) Returns the number of duplicates for a given key item. <Source>.ReadSeekFirst (Function) Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). HOpen (Function) Opens a data file. HError (Function) Returns the number of the last error triggered by the HFSQL engine. HErrorStatusModification (Function) Returns the status of a record during a modification conflict. <Source>.MigrateLinkedCompositeKey (Function) Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. HSetIntegrity (Function) Enables or disables the management of an integrity constraint on a file link. HRead (Function) Reads a record in a file according to a given record number. <Source>.SetMemo (Function) Used to modify the management mode of memo items. HListFullTextIndex (Function) Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. HTransactionSavepoint (Function) Declares a transaction savepoint. <Source>.UnlockFile (Function) Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function. HWrite (Function) Writes a record into a data file without updating the indexes corresponding to all keys used in the file. <Source>.ListStopWord (Function) Returns the list of stop words used by a full-text index. <Source>.ExecuteQueryAsynchronous (Function) Executes a SELECT query asynchronously. HUnlockRecNum (Function) Unlocks a record locked by: HLockRecNum, a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example). HDescribeTrigger (Function) Adds or modifies a trigger on an HFSQL data file. HErrorInfo (Function) Returns a detailed information about the last error triggered by the HFSQL engine. <Source>.Seek (Function) Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). HReadSeekLast (Function) Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). HListKey (Function) Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. HExportXLS (Function) Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). 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. <Source>.Reset (Function) Initializes: one or all variables of file items with their default values. one or all items of a Record variable with their default values. <Source>.DeactivateFilter (Function) Temporarily disables the filter on a data file (view or query). HDescribeLink (Function) Describes a link between two data files programmatically. HListSynonym (Function) Returns the list of synonyms used by a full-text index. <Source>.Found (Function) Checks whether the current record corresponds to the current filter or search. <Connection variable>.TransactionSavepoint (Function) Declares a transaction savepoint. HCheckStructure (Function) Defines the mode for comparing data files. HReadPrevious (Function) Sets the position on the previous record of a file according to a browse item. HUnlockFile (Function) Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function. HReadSeekFirst (Function) Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). Link functions Link functions are used to link the interface with the data files and vice versa. These functions are as follows: 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 data file. Item Description (Variable type) An Item Description variable is used to describe one or more items in a data file programmatically. <Source>.Read (Function) Reads a record in a file according to a given record number. <Source>.ImportHF55 (Function) Imports a Hyper File 5.5 file into an HFSQL Classic file. HTransactionStart (Function) Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. <Source>.ListKey (Function) Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. Filtering a data file, a view or a query A filter is used to define through programming a selection of records corresponding to one or more criteria... HLast (Function) Sets the position on the last record of a data file according to a browse item. HImportHF55 (Function) Imports a Hyper File 5.5 file into an HFSQL Classic file. <Source>.StatTime (Function) Returns the time of the last update for the index statistics. <Source>.UnlockRecNum (Function) Unlocks a record locked by: HLockRecNum, a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example). HPrevious (Function) Sets the position on the previous record of the data file according to a browse item. <Source>.ListSpatialKeys (Function) Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. <Source>.IndexingInProgress (Function) Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. <Source>.Backward (Function) Moves backward several records from the current position in the data file, according to a specified item. <Source>.CheckMemo (Function) Checks the structural integrity of memos in an HFSQL data file. <Connection variable>.TransactionStart (Function) Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. <Source>.ReadSeekLast (Function) Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). <Source>.ImportCSV (Function) Imports a CSV file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). HListTrigger (Function) Returns the list of triggers applied to one or more HFSQL data files. <Source>.Open (Function) Opens a data file. HMigrateLinkedCompositeKey (Function) Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. HNext (Function) Sets the position on the next data file record according to a browse item. <Source>.First (Function) Sets the position on the first record of a data file according to the specified browse item. HExecuteQueryAsynchronous (Function) Executes a SELECT query asynchronously. <Connection variable>.DeleteTask (Function) Deletes a scheduled task from an HFSQL Client/Server server.... <Connection variable>.ModifyServerRights (Function) Modifies the rights granted to a user or to a group on a HFSQL server. <Connection variable>.ModifyFileProperty (Function) Modifies the properties of an HFSQL data file located on a server. <Connection variable>.ModifyTask (Function) Modifies a scheduled task on the HFSQL server defined by the connection. FOR EACH/FOR ALL statement (loop through files) The FOR EACH statement is used to run different types of HFSQL loops... HModifyServerRights (Function) Modifies the rights granted to a user or to a group on an HFSQL server. HDeleteQuery (Function) Deletes a query (used by stored procedures) from an HFSQL server. <Connection variable>.OperationInProgress (Function) Returns the list of automatic operations in progress on an HFSQL server. <Connection variable>.RSModifyConfig (Function) Modifies some parameters of an existing replication between two HFSQL servers. <Connection variable>.DeleteQuery (Function) Deletes a query (used by stored procedures) from an HFSQL server. <Connection variable>.DeleteScheduledBackup (Function) Deletes a scheduled backup from an HFSQL Client/Server server.... <Connection variable>.DeactivateServerTrigger (Function) Disables a HFSQL Client/Server server trigger on a server.... <Connection variable>.TransactionIsolation (Function) Configures the isolation mode of transactions for a connection to an HFSQL server. WDHFDiff - Use WDHFDiff is used to compare...... ExtendedInfo (Property) by a Native Connector or HFSQL Client/Server. about an item accessed by a Native Connector or HFSQL... Using the Control Centers in Client/Server mode All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...... HManageTask (Function) Enables or disables a scheduled task on an HFSQL Client/Server server.... HSetServer (Function) Used to find out and modify some settings of HFSQL Client/Server server.... HClusterStart (Function) Starts an HFSQL cluster. This cluster was stopped beforehand (by HClusterStop for example). HAddScheduledOptimization (Function) Adds an optimization task of HFSQL Client/Server data files.... HListScheduledBackup (Function) Lists the full and differential backups that have been scheduled on HFSQL Client/Server.... HModifyScheduledOptimization (Function) Modifies a scheduled optimization task on the HFSQL server defined by the connection.