ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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......
<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 file....
CtDescribedCaption (Property)
The CtDescribedCaption property is used to get and set the caption of the connection to the OLE DB data source.
GUIDFile (Property)
The GUIDFile property returns the GUID of the file defined in the analysis that was used to create the data file.
InitialFile (Property)
The InitialFile property is used to get the original name of the data file associated to an item in a query.
OperationLogDirectory (Property)
The OperationLogDirectory property is used to manage the directory of the operation log file associated with a data file.
LooperModifyLine (Function)
Changes the values of the attributes in a row of a Looper control based on a data file or populated programmatically.
fDataDir (Function)
Returns the full path of the directory of HFSQL data files specified by the user when installing the application.
TableSelectToFile (Function)
Positions on the data file record corresponding to a row selected in the multiselection browsing Table control.
FileToMemoryList (Function)
Populates a List Box or Combo Box control programmatically with the records from a data file or query.
HWrite (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
HDeleteFile (Function)
Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
<Source>.CheckUnaltered (Function)
Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example).
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.
<HFSQL file>.ExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
<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.