ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Query editor
The query editor is used to automatically create queries on the data files......
HFSQL Client/Server database: Recommendations
This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features......
Native SQLite Connector: Programming with SQL functions
The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis....
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......
4. HFSQL Classic
WINDEV and the SOAP protocol
HDeleteScheduling (Function)
Deletes a scheduled task found on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
HListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
Optimizing the connection times to the HFSQL Client/Server databases
This help page explains how to optimize the connection times to the HFSQL Client/Server databases by limiting the network traffic......
<Source>.MergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Connection variable>.ListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
FilterCondition (Property)
The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
HMergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
Access (Property)
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.)....
Database (Property)
The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.)....
ExecutionCompleted (Property)
The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed....
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
HRecordDate (Function)
Returns the date and time of the last write operation performed on a record in an HFSQL file (Classic or Client/Server)....
<Connection variable>.Backup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
<Connection variable>.DeleteScheduling (Function)
Deletes a scheduled task found on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
Creating a select query
A select query (corresponding SQL statement......
Modifying an SVG image (XML functions)
SVG (Scalable Vector Graphics) is a vector image format......
Variant (Type of variable)
The Variant type is used to: store any simple value: boolean, numeric (Currency, Real, Integer, etc.), characters and character string, date (Date, Time, DateTime and Duration), ... store named or indexed subelements. store any complex value: structures, classes, advanced types, arrays, associative arrays, queues, stacks and lists. handle the NULL value in WLanguage. store interactions with ActiveX objects and Automation programming....
Error 31: The file to include is not found. Check the name and path ...