ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<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.
Importing tables into the database schema (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
<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.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
FTPGet (Function)
Transfers a file or directory from an FTP (File Transfer Protocol) server to the current computer.
hScheduledTask (Variable type)
The hScheduledTask type is used to manage a scheduled HFSQL Client/Server task through programming......
HModifyItemRights (Function)
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table....
GglConnect (Function)
Manages authentication on a Google server (via the "OAuth 2.0" authentication mode).
HDeleteFile (Function)
Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
hScheduledOptimization (Variable type)
The hScheduledOptimization type is used to programmatically manage a scheduled optimization task on an HFSQL server.
WBAdminListApplication (Function)
Returns the list of applications on a WEBDEV Application Server, for a given account and a given type.
AppActivateVersion (Function)
Activates one of the application versions available in the history of versions on the reference setup server.
HSimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
Captcha control properties
The Captcha control can be handled by the WLanguage properties in server code and in browser code.
HRetrieveBackup (Function)
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
mongoCollection (Variable type)
The mongoCollection type is used to define the advanced characteristics of a collection in a database of a MongoDB server.
BitcoinCoreConfigure (Function)
Specifies the Bitcoin Core server connection parameters, in order to use BitcoinCoreXXXX functions.
Pager control properties
The WLanguage properties are used to handle the Pager control in server code and in browser code......
<Connection variable>.SimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
Differences and specific features of an HFSQL Client/Server application
The management mode of tables may have to be adapted when using an HFSQL Client/Server application......
<Connection variable>.AddScheduledBackup (Function)
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data......
<WBadminAuth variable>.ListApplication (Function)
Returns the list of applications on a WEBDEV Application Server, for a given account and a given type.
<Connection variable>.ModifyItemRights (Function)
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table....
iFrame control properties
The iFrame control can be handled in server code and in browser code by the WLanguage properties......
FTPSize (Function)
Returns the size (in bytes) of a file located on an FTP server (File Transfer Protocol).
HAddScheduledBackup (Function)
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
Testing and debugging a remote site
WEBDEV offers several methods to test and debug a site on the development computer (see The different types of WEBDEV sites)......
Managing short URLs automatically
For the standard dynamic sites (with context), the access to the site can be done via a "standard" URL:...