ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Implementing the log process in an application
Regardless of the data files used by your application (HFSQL Classic or HFSQL Client/Server), the log process can be implemented on these data files......
Pivot Table control in a report
The report editor allows you to create "Crosstab" reports......
zipInfoFile (Function)
Returns the characteristics of a file found an archive: The name of the file and its stored path. The initial size of the file. The compressed size of file. The date and time of file creation. The date and time of file modification. The date and time of file access. The file attributes. The file encryption mode....
HFSQL data files exceeding 2 gigabytes
By default, the HFSQL engine allows you to manage large data files (up to 2 gigabytes)......
<zipArchive variable>.InfoFile (Function)
Returns the characteristics of a file found an archive: The name of the file and its stored path. The initial size of the file. The compressed size of file. The date and time of file creation. The date and time of file modification. The date and time of file access. The file attributes. The file encryption mode....
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.
Native SQL Server Connector: Programming with HFSQL functions
To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis......
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....
FilterWithBounds (Property)
The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
HChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
SQLite: Programming with HFSQL functions
To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor....
Key and referential integrity
In an analysis, the "Key" items are also used to manage the consistency of data (called referential integrity)......
Creating an executable
Once the development of your WINDEV application is completed (windows, reports, queries, etc....
Transactions: Secure processes on HFSQL data files
This chapter presents the following topics......
Live Data: viewing data in the editors
The "Live Data" is used to view the content of the data files in the controls currently created in the different editors of the product used (window editor, page editor, report editor, ......
<Source>.ImportJSON (Function)
Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).
Native DB2 Connector : Programming with SQL functions
The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis......
HImportJSON (Function)
Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).
fCreate (Function)
Creates an external file.
<Variable DiskFile>Create (Function)
Creates an external file.
<Document variable>.ToText (Function)
Creates a character string with the data of a Document variable.
ControlCreate (Function)
Creates a new control (of any type) in a window through programming.
HImportXML (Function)
Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportXML (Function)
Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile)....