ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HListConnection (Function)
Returns the list of connections currently described in the application:
  • connections described in the data model editor (for the main analysis and, if necessary, additional analyses).
  • connections described by programming (with functions HDescribeConnection or HOpenConnection).
<Source>.ChangeConnection (Function)
Dynamically changes the connection associated with a data file.
SQLConnect (Function)
Connects the current application to a database that must be interrogated via SQL.
SQLChangeConnection (Function)
Modifies the current connection.
HDescribeConnection (Function)
Describes a new connection to an external database.
<Connection variable>.OpenConnection (Function)
Opens a connection to a specific database.
HConnect (Function)
Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables.
Optional connection information
When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information...
<Connection variable>.CloseConnection (Function)
Closes a connection to a database.
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP).
HListFile (Function)
Returns the list of files:
  • current analysis.
  • analyses in progress (projects with multiple analyses).
  • a specific analysis recognized by the HFSQL engine.
  • available on a connection via a Native Connector or an OLE DB driver.
  • for a group of files defined in the data model editor.
HOpenConnection (Function)
Opens a connection to a specific database.
HChangeConnection (Function)
Dynamically changes the connection associated with a data file.
<Connection variable>.UpdateView (Function)
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
<Connection variable>.ModifyFileRights (Function)
Modifies the rights granted to a user or group on an HFSQL Client/Server data file....
<Connection variable>.ModifyServerRights (Function)
Modifies the rights granted to a user or to a group on a HFSQL server.
<Connection variable>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
<Connection variable>.InfoGroup (Function)
Returns information about the specified group of users.
<Connection variable>.UpdateQuery (Function)
Creates or updates a query on an HFSQL server.
<Connection variable>.InfoFileProperty (Function)
Allows you to find out the properties of a data file located in an HFSQL server.
<Connection variable>.InfoServerProperty (Function)
Allows you to find out the properties of an HFSQL server.
<Connection variable>.InfoServer (Function)
Returns the specified information about the server.
<Connection variable>.InfoTask (Function)
Returns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.InfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
<Connection variable>.InfoView (Function)
Returns information about a materialized view.
<Connection variable>.ModifyViewRights (Function)
Modifies the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.ModifyGroup (Function)
Modifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.ModifyScheduling (Function)
Modifies a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
<Connection variable>.ModifyFileProperty (Function)
Modifies the properties of an HFSQL data file located on a server.
<Connection variable>.ModifyServerProperty (Function)
Modifies the properties of an HFSQL server.
<Connection variable>.ModifyUser (Function)
Modifies the information about a user according to the elements found in the corresponding variables for user management.
<Connection variable>.NotifAddCCRecipient (Function)
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifAddEmailRecipient (Function)
Adds recipients for the notifications sent by email.
<Connection variable>.NotifConfigure (Function)
Specifies and configures the server used to send notifications by the HFSQL server.
<Connection variable>.NotifListCCRecipient (Function)
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
<HFSQL connection>.TransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
<HFSQL connection>.TransactionSavepoint (Function)
Declares a transaction savepoint.
<HFSQL connection>.RSRenameServer (Function)
Changes the DNS name of the replication server if it has a new name.