ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Importing data files into the analysis (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
HModifyScheduling (Function)
Modifies a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
appServerScheduledTask (Type of variable)
The appServerScheduledTask type is used to manage a scheduled task of WEBDEV Application Server through programming (for a site or a webservice).
HTrack (Function)
Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server.
<Source>.Track (Function)
Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server.
<Connection variable>.AddScheduling (Function)
Creates a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
<Connection variable>.ModifyScheduling (Function)
Modifies a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
WEBDEV administrator: Characteristics of current connections
The "Connections" tab gives various information about the current connections......
Creating a WINDEV SOAP Server application
The SOAP Server application is an application containing all the procedures to run......
HFSQL Client/Server management functions
Several HFSQL functions are used to manage the HFSQL Client/Server data......
Provider (Property)
The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.)....
User (Property)
The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.)....
Troubleshooting
This chapter presents the main problems (and their solutions) that can occur when using the WEBDEV Application Server...
WEBDEV Application Server remote control functions (prefix syntax)
The following functions are used to manage users and connections on a WEBDEV Application Server, using prefix syntax:
WEBDEV Application Server 2024
4. HFSQL Classic
WDSQL: Creating and running a script
A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ......
HFSQL: Change of name
Printing a report in WEBDEV
When creating a report, the test of this report can be run from the report editor. You also have the ability to include this report in your sites. The Web user will have the ability to print the report from a button, a menu option, ... for example....
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......
<Connection variable>.ListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
WEBDEV administrator: General configuration
The "Configuration" tab is used to define the default connection options for the WEBDEV sites found on the server and managed by the administrator......
ChangeAction (Function)
Used to specify the action to perform when the HTML page displayed in the browser is no longer synchronized with the page context on server.
FTPRemoveDir (Function)
Deletes a directory and its content (files and sub-directories) from an FTP server (File Transfer Protocol).