ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

WDSQL: Connecting to a database
The first operation to perform in order to use WDSQL is to establish the connection to a database......
<Connection variable>.ModifyGroup (Function)
Modifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.InfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
<Connection variable>.ModifyServerRights (Function)
Modifies the rights granted to a user or to a group on a HFSQL server.
<Connection variable>.InfoDatabaseRights (Function)
Allows you to find out the rights granted to a user or to a group on a database.
<Connection variable>.ExecuteScheduledBackup (Function)
Forces the execution of a scheduled backup.
<Connection variable>.InfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
<Connection variable>.DeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
BTLEConnectionStatus (Function)
Returns the current connection status to a Bluetooth Low Energy device or asks to be notified when the connection status changes.
<btleDevice variable>.ConnectionStatus (Function)
Returns the current connection status to a Bluetooth Low Energy device or asks to be notified when the connection status changes.
<Connection>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
MobileNetworkStatus (Function)
Returns the current status of the connection to data on the mobile network or asks to be notified when the status of the connection to data changes.
Errors while managing data files
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError......
<Connection variable>.UpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.
<Connection variable>.InfoGroup (Function)
Returns information about the specified group of users.
<Connection variable>.InfoTask (Function)
Returns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.ModifyUser (Function)
Modifies the information about a user according to the elements found in the corresponding variables for user management.
<Connection variable>.ListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
InternetConnected (Function)
Defines whether an Internet connection is enabled on the current computer. In mobile, you can also be notified when the status of the Internet connection changes.
Application triggers
...A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file....
HCS.Timeout (Variable)
The HCS.Timeout variable is used to modify the connection timeout: for the connections established by HOpenConnection. for the automatic connection openings....
WBAdminConnection (Type of variable)
The WBAdminConnection type is used to get all the advanced characteristics of a connection on the server. This connection can correspond to a session, an AWP request, a schedule task, etc.
<Connection variable>.CloseConnection (Function)
Closes a connection to a database.
HCloseConnection (Function)
Closes a connection to a database.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.