ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Mathematical SQL functions
The mathematical SQL functions that can be used on the queries written in SQL code are as follows......
HImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
7. Creating HFSQL files: files physically created
The data model editor allows you to define the structure of the data files....
<Source>.ImportText (Function)
Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
HAdd (Function)
Adds: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view)....
JITc
The principle of JITc technology (Just In Time Compilation) is straightforward......
NFC: Transferring data
NFC (Near Field Communication) is a wireless communication technology at short range and high frequency used to exchange data (named "tag") between two devices or between a device and a bullet even at short distance (few centimeters)......
MongoGridFSGetFileByID (Function)
Retrieves (on the local computer) a file identified by its identifier and found in a MongoDB file system.
MongoGridFSGetFile (Function)
Retrieves (on the local computer) a file identified by its name and found in a MongoDB file system.
<zipArchive variable>.CurrentFile (Function)
Returns the name of the archived file currently handled by the functions for adding and extracting files.
SynchroHFSQL (Property)
The SynchroHFSQL property is used to: get the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file. specify the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file....
<mongoGridFS variable>.GetFileByID (Function)
Retrieves (on the local computer) a file identified by its identifier and found in a MongoDB file system.
<zipArchive variable>.ExtractDirectory (Function)
Automatically extracts and decompresses files from a directory in the file tree of an archive to a physical location.
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
<Source>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
grDestinationEMF (Function)
Defines a meta file as chart destination (EMF means Enhanced Meta File).
HChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
HInfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
zipCurrentFile (Function)
Returns the name of the archived file currently handled by the functions for adding and extracting files.
Structure of log files (HFSQL Client/Server)
The following files are automatically created when logging an HFSQL Client/Server data file......
<Connection>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
<mongoGridFS variable>.GetFile (Function)
Retrieves (on the local computer) a file identified by its name and found in a MongoDB file system.
Size (Property)
The Size property is used to determine and change the size of an element.
List,Search (External language)
Finds a value in a list.