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.
FTPDisconnect (Function)
Closes the connection between the current computer and the FTP server (File Transfer Protocol).
FTPRenameFile (Function)
Renames or moves a file found on an FTP server (File Transfer Protocol).
FTPCurrentDir (Function)
Identifies or modifies the current directory on an FTP server (File Transfer Protocol).
OLECreateEmpty (Function)
Associates an OLE control with an OLE object by invoking a specific OLE server.
OLEPlay (Function)
Used to: retrieve the list of available operations (other than edit) from a server, perform an operation....
HModifyDatabaseRights (Function)
Modifies the rights granted to a user or to a group for a HFSQL Client/Server database....
AJAXAsynchronousCallPending (Function)
Used to find out whether a server procedure called by AJAXExecuteAsynchronous is currently run.
LDAPConnect (Function)
Used to connect to an LDAP server via the characteristics defined in the LDAPSession structure.
WebSocket functions (prefix syntax)
List of functions specific to WebSocket servers...
<Connection variable>.RetrieveLog (Function)
Creates a text file containing the server logs between two given dates.
<Connection variable>.RSInfo (Function)
Reads the replication configuration for an HFSQL server that takes part in one or more replications.
<Connection variable>.DeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server data files....
<Connection variable>.ListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection....
FTPAttribute (Function)
Identifies the attributes of a file located on an FTP server (File Transfer Protocol).
ModbusConnectTCP (Function)
Connects a client to a Modbus server via transmission control protocol (TCP).
HInfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server table....
hServerOperation (Variable type)
The hServerOperation type is used to get the characteristics of an operation performed on an HFSQL server.
UploadDelete (Function)
Deletes a file from the list of files to upload: the file will not be uploaded on the server.
PageToASP (Function)
Sends the data found in a page currently displayed in the browser to an ASP server.
memcachedResult (Variable type)
The memcachedResult type is used to define the characteristics of a value read on a Memcached server.