ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

<HFSQL file>.ExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
HDeleteFile (Function)
Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
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......
HBackward (Function)
Moves backward several records from the current position in the data file, according to a specified item.
HTransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
H.VisibleAutoIndexing (Variable)
Indicates whether the indexing window must be displayed during the automatic reindexing of HFSQL data files.
HForward (Function)
Moves several records forward from the current position in the data file, according to a specified item.
HCreation (Function)
Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
HDBOpenNoLock (Function)
In single-user mode, opens an xBase data file without locking it.
HUnlockFile (Function)
Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function....
HInfoFileRights (Function)
Allows you to find out the rights granted to a user or to a group on an HFSQL Client/Server data file....
HExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
HWrite (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
<Connection variable>.DeleteFile (Function)
Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
<Connection variable>.TransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
Differences and specific features of an HFSQL Client/Server application
The management mode of data files may have to be adapted when using an HFSQL Client/Server application......
Minute (Property)
The Minute property is used to: Retrieve the minutes from a Time or DateTime variable, or the number of minutes from a Duration. Change the minutes in a Time or DateTime variable, or the number of minutes in a Duration. Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item. Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item....
5. HFSQL Client/Server
11. Table/Looper controls
Table/Looper controls can be used to display a set of information......
Type of item: Secure password
"Password" items are used to securely store passwords by using a salt and a hash algorithm......
Context menu of TimeLine controls
By default, TimeLine controls contain a context menu....
HCopyFile (Function)
Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the data files for example). from an HFSQL server to antoher HFSQL server....
Using offline sites
WEBDEV allows you to specify that a site or a set of pages can operate in off-line mode (without an Internet connection)....
<Connection variable>.CopyFile (Function)
Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the data files for example). from an HFSQL server to antoher HFSQL server....
Report based on a query
Queries are used to easily select records in one or more data files......