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.
<Connection variable>.ModifyFileRights (Function)
Modifies the rights granted to a user or group on an HFSQL Client/Server data file....
FTPGet (Function)
Transfers a file or directory from an FTP (File Transfer Protocol) server to the current computer.
FTPSize (Function)
Returns the size (in bytes) of a file found on an FTP server (File Transfer Protocol).
HListConnectedUser (Function)
Lists the users currently connected to one or more files handled by a Client/Server connection....
NetClientSendMessage (Function)
Sends a message from the server to all the connected client computers. This function is kept for backward compatibility....
SocketWaitForConnection (Function)
Run on the server, this function is used to wait for a connection request coming from the client sockets.
HModifyFileRights (Function)
Modifies the rights granted to a user or group on an HFSQL Client/Server data file....
Structure of log files (HFSQL Client/Server)
The following files are automatically created when logging an HFSQL Client/Server data file......
<Connection variable>.RetrieveBackup (Function)
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
<Connection variable>.SimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
BitcoinCoreConfigure( Function)
Specifies Bitcoin Core server connection parameters, in order to use BitcoinCoreXXXX functions.
Properties associated with a page
iFrame control properties
The iFrame control can be handled in server code and in browser code by the WLanguage properties......
Captcha control properties
The Captcha control can be handled by the WLanguage properties in server code and in browser code.
Pager control properties
The WLanguage properties are used to handle the Pager control in server code and in browser code......
Upload control properties
The Upload control can be handled in server code and in browser code by the WLanguage properties......
<Connection variable>.DeleteFile (Function)
Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
PageWriteHTTPCode (Function)
Specifies the HTTP code that will be returned to the client after the server code of the page is executed.
<gglConnection variable>.Connect (Function)
Manages authentication on a Google server (via the "OAuth 2.0" authentication mode).
redisConnection (Variable type)
The redisConnection type is used to define all the advanced characteristics of a connection to a Redis server (or cluster).
ActiveDirectory (Property)
The ActiveDirectory property allows you to connect to an HFSQL server using Active Directory authentication.