ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

<Variable Connexion>.RSIgnoreError (Function)
Ignores errors so that replication between HFSQL servers can continue to run.
Connection
The Connection keyword can correspond to:
  • the Connection variable.
  • the Connection property used to get and change the connection currently associated with a table.
    For more details, see Connection.
  • the Connection property of a hbScanParameter variable.
<Connection variable>.InfoServerProperty (Function)
Allows you to find out the properties of an HFSQL server.
Native Progress Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to Progress ...
oDriveConnect (Function)
Creates a connection to OneDrive.
<Connection variable>.EndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
<Connection variable>.ListUser (Function)
Returns the list of users defined for a connection.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
hbColumn (Variable type)
The hbColumn type is used to define the advanced characteristics of a column (item) in an HBase table.
Connection (Property)
The Connection property gets and sets the connection associated with a table.
<Connection variable>.InfoDatabaseProperty (Function)
Used to find out the properties of a database on an HFSQL server.
<Connection variable>.RSListConfig (Function)
Lists the replications available on a master HFSQL server.
<sfConnection variable>.Search (Function)
Performs a search among the records found in a Salesforce database.
<Connection variable>.ModifyServerProperty (Function)
Modifies the properties of an HFSQL server.
<Connection variable>.AddLink (Function)
Adds an integrity rule between two files on the server.
<Connection variable>.PriorityClient (Function)
Modifies the priority of a client application.
<sfConnection variable>.Delete (Function)
Deletes records from a Salesforce database.
<sfConnection variable>.Add (Function)
Creates a record in a file of a Salesforce database.
<Connection variable>.LoadParameter (Function)
Reads a parameter that was saved from a stored procedure by HSaveParameter.
<Connection variable>.Priority (Function)
Finds out and modifies the priority of the calling application.
<Connection variable>.InfoTask (Function)
Returns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.UpdateQuery (Function)
Creates or updates a query on an HFSQL server.
<sfConnection variable>.SeekModified (Function)
Seeks and retrieves the records (Salesforce objects) modified during the specified period.
<sfConnection variable>.ExecuteQuery (Function)
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
<sfConnection variable>.Read (Function)
Retrieves the Salesforce records from their identifiers.
<sfConnection variable>.EmptyRecycleBin (Function)
Clears the specified records from the Salesforce recycle bin.
<sfConnection variable>.ForwardQuery (Function)
Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.
<Connection variable>.DisconnectClient (Function)
Displays a message on the Client computer(s) and disconnects the application.
<Connection variable>.OperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.ModifyDatabaseProperty (Function)
Modifies the properties of a database located on an HFSQL server.
<modbusSession>.ReadRegister (Function)
Reads one or more registers from a Modbus slave, starting at a specific address.
<modbusSession>.ReadBit (Function)
Reads one or more bits from a Modbus slave, starting at a specific address.
SAP variable
The SAP variable is used to configure the parameters of the connection to the SAP server...
<Connection variable>.NotifAddCCRecipient (Function)
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
<Connection variable>.RefreshView (Function)
Asks to recalculate the content of a materialized view.
<modbusSession>.WriteBit (Function)
Writes one or multiple bits to a specific address in a Modbus slave.
AuthRefreshToken (Function)
Refreshes a user's OAuth2 token when it expires.
<AuthToken>.RefreshToken (Function)
Refreshes a user's OAuth2 token when it expires.
<Connection variable>.DuplicateDatabase (Function)
Duplicates the database associated with a connection on an HFSQL server.
<Connection variable>.ListWatchedFiles (Function)
Returns the list of tables watched by HWatch.
<Connection variable>.UpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.
<Connection variable>.RetrieveLog (Function)
Creates a text file containing the server logs between two given dates.
SQLTransaction (Function)
Begins, commits or rolls back a transaction:
  • on the files of a database opened by SQLConnect,
  • on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.
<Connection variable>.ModifyServerRights (Function)
Sets the rights granted to a user or group on an HFSQL server.
<Connection variable>.ModifyViewRights (Function)
Sets the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.InfoView (Function)
Returns information about a materialized view.
<modbusSession>.Disconnect (Function)
Closes the Modbus session.
<Connection variable>.DeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server tables.
<Connection variable>.NotifDeleteCCRecipient (Function)
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
<modbusSession>.WriteRegister (Function)
Writes one or more registers (16-bit values) to a Modbus slave, starting at a specific address.
<Connection variable>.CancelBackup (Function)
Cancels a current backup.
<Connection variable>.DeleteScheduledBackup (Function)
Deletes a scheduled backup from an HFSQL Client/Server server.
<Connection variable>.DeleteQuery (Function)
Deletes a query (used by stored procedures) from an HFSQL server.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
Drive (Variable type)
The Drive type is used to handle online storage services. To use this type of variable, you need to connect to the desired service.
<Connection variable>.CloseConnection (Function)
Closes a connection to a database.
<Connection variable>.DeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
<Connection variable>.ModifyScheduledOptimization (Function)
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
<Connection variable>.TransactionSavepoint (Function)
Declares a transaction savepoint.
<Connection variable>.ModifyScheduledBackup (Function)
Modifies a backup scheduling.
<Connection variable>.StopServer (Function)
Stops an HFSQL server.
<Connection variable>.DeleteUser (Function)
Deletes a user associated with a connection to the HFSQL server.
<Connection variable>.DeleteFile (Function)
Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
<Connection variable>.ExecuteAsynchronousProcedure (Function)
Executes a stored procedure in asynchronous mode.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.CheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Connection variable>.ListScheduling (Function)
Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view.
<Connection variable>.InfoFileProperty (Function)
Allows you to find out the properties of a table located in an HFSQL server.
<Connection variable>.ConnectionQuality (Function)
Returns the quality level of the connection: the higher the level is, the faster the connection is.
<Connection variable>.AddUser (Function)
Adds a user to a database.
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
<Connection variable>.ModifyFileProperty (Function)
Modifies the properties of an HFSQL table located on a server.
<Connection variable>.NotifAddEmailRecipient (Function)
Adds recipients for the notifications sent by email.
<Connection variable>.ListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection.
<Connection variable>.RSAddConfig (Function)
Adds a replication between two HFSQL server onto the master server.
<Connection variable>.AddGroup (Function)
Adds a group of users.
<Connection variable>.ModifyGroup (Function)
Modifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.ExecuteProcedure (Function)
Runs a stored procedure.
Setting up and using a Bitcoin Core server
WLanguage offers several functions for manipulating a Bitcoin Core 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>.TransactionCancel (Function)
If a transaction is in progress, rolls back all operations performed on tables in transactions since the start of the transaction.
<Connection variable>.ListTask (Function)
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
<Connection variable>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server table.
<Connection variable>.SaveParameter (Function)
Saves a persistent value on the HFSQL server.
<Connection variable>.InfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
<Connection variable>.InfoLock (Function)
Returns information about the lock set on a table, on one or all the records in a table.
<Connection variable>.InfoGroup (Function)
Returns information about the specified group of users.
<Connection variable>.SecurityPolicyCheck (Function)
Checks that each user accounts complies with the password security policy associated with the HFSQL server.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3.
<Connection variable>.NotifListCCRecipient (Function)
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
<Connection variable>.RSTransformSpareIntoServer (Function)
Transforms a Spare server into an HFSQL server. This makes it possible to delete replications of a spare server so that it can be used again. For example, this function can be used in the case of a master server that becomes unreachable.
This function should only be used in a critical situation.
Note: This function is only available from version 2025 Update 1.
<Connection variable>.NotifListEmailRecipient (Function)
Returns the list of recipients for a notification by email.
<Connection variable>.DeleteParameter (Function)
Deletes a parameter previously saved by HSaveParameter.
<Connection variable>.SecurityPolicyGet (Function)
Gets the security policy of an HFSQL server.
This new function is available from version 2025 Update 3.
<HFSQL connection>.ListReindexingHistory (Function)
Lists the operations performed on current tables, over the last 24 hours, or on the last 1000 tables. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Connection variable>.DeleteDatabase (Function)
Deletes a database located on an HFSQL server.
<Connection variable>.SecurityPolicyUnlockAccount (Function)
Unlocks a user account that has been locked due too many unsuccessful login attempts.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3.
<Connection variable>.FileExist (Function)
Finds out if a file exists, i.e. if it has been physically created (HCreate or HCreationIfNotFound).
<Connection variable>.ManageTask (Function)
Enables or disables a scheduled task on an HFSQL Client/Server server.
<Connection variable>.DeactivateServerTrigger (Function)
Disables an HFSQL Client/Server server trigger on a server.
<Connection variable>.ActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.SecurityPolicySet (Function)
Sets the password security policy of an HFSQL server.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3.
<Connection variable>.NoDatabaseAccess (Function)
Denies all new connections to a database or to all databases.
gglAttachment (Variable type)
The gglAttachment type is used to define all the advanced characteristics of a file attached to a calendar event. The calendar can be described using the gglCalendar type. This calendar is used by the Google Calendar service.
<Connection variable>.DeleteGroup (Function)
Deletes (from the server) a group of users associated with a connection.
<Connection variable>.DeleteDirectory (Function)
Deletes a directory from an HFSQL Client/Server database.
<Connection variable>.RSInfo (Function)
Reads the replication configuration for an HFSQL server that takes part in one or more replications.
<Connection variable>.ListParameter (Function)
Returns the list of parameters saved from the stored procedures on the server.
<Connection variable>.ExecuteScheduledBackup (Function)
Forces the execution of a scheduled backup.
<Connection variable>.ListGroup (Function)
Returns the list of groups of users defined for a connection.
<Connection variable>.RSModifyConfig (Function)
Modifies some parameters of an existing replication between two HFSQL servers.
<Connection variable>.DeleteServerTrigger (Function)
Deletes a server trigger.
<gglConnection variable>.GetDocument (Function)
Downloads a document from Google Docs.
<Connection variable>.SimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
<Connection variable>.ModifyTask (Function)
Modifies a scheduled task on the HFSQL server defined by the connection.
<Connection variable>.InfoServer (Function)
Returns the specified information about the server.
Changing sites from AWP to SEO-ready session mode
A query created in the query editor can contain several types of items...
<Connection variable>.InfoViewRights (Function)
Gets the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.TransactionIsolation (Function)
Configures the isolation level of transactions for a connection to an HFSQL server.
<Connection variable>.DeleteTask (Function)
Deletes a scheduled task from an HFSQL Client/Server server.
<Connection variable>.TransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
<Connection variable>.DeleteBackup (Function)
Deletes a backup previously created with HBackup.
<Connection variable>.DeleteLink (Function)
Deletes an integrity rule between two tables on the server.
HDeclareExternal (Example)
Usage example of the HDeclareExternal function
Connection (Variable type)
The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.
<Connection variable>.RSDeleteConfig (Function)
Deletes a replication between two HFSQL servers.
<Connection variable>.ListDatabase (Function)
Lists the Client/Server databases associated with a connection.
<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>.RSInit (Function)
Configures an HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
<Connection variable>.ListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
HRSIgnoreError (Function)
Ignores errors so that replication between HFSQL servers can continue to run.
<Connection variable>.RetrieveBackup (Function)
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
<Connection variable>.InfoBackup (Function)
Returns information about one or more backups performed on an HFSQL Client/Server server.
ReplicAdmin: Overview
Stops the video recording previously started by CameraVideoStart.
<Connection variable>.ListSchedulingHistory (Function)
Lists the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
<Connection variable>.AddTask (Function)
Adds a scheduled task on the server defined by the connection.
<Connection variable>.ListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server.
<Connection variable>.Transaction (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
<Connection variable>.InfoItemRights (Function)
Gets the rights granted to a user or group on an item.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<Connection variable>.CheckServerUpdate (Function)
Checks for the latest version of the HFSQL server that can be automatically updated.
<Connection variable>.ManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
<Connection variable>.SetIntegrity (Function)
Enables or disables the management of an integrity constraint on a file link.
<HFSQL connection>.StatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Connection variable>.RegenerateFile (Function)
Regenerates a table from its log.
<Connection variable>.AddScheduling (Function)
Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view.
<Connection variable>.AddScheduledBackup (Function)
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
<Connection variable>.TransactionEnd (Function)
Validates the current transaction:
  • the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
<Connection variable>.ModifyFileRights (Function)
Sets the rights granted to a user or group on an HFSQL Client/Server table.
<Connection variable>.RSExecute (Function)
Immediately execute periodic replication between HFSQL servers: replication is triggered ahead of schedule.
Parameters of the procedure used by the ProximityShareAttendConnection function (Notification)
WLanguage procedure (also called "callback") called by the ShareProximityAttendConnection function to notify the connection status with a remote device.t
<Connection variable>.OpenConnection (Function)
Opens a connection to a specific database.
<Connection variable>.DropView (Function)
Deletes a materialized view from the HFSQL server.
<Connection variable>.TransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
<Connection variable>.InfoServerRights (Function)
Gets the rights granted to a user or group of users on a server.
<Connection variable>.NotifDeleteEmailRecipient (Function)
Deletes the recipients of an email notification.
DeclareWebserviceContext (Function)
Used to declare a list of variables whose value will be persistent between the successive calls to a web service.
<Connection variable>.ModifyDatabaseRights (Function)
Sets the rights granted to a user or group for an HFSQL Client/Server database.
<Connection variable>.RSWaitForDataProcess (Function)
Waits for:
  • the replication data on the master server to be sent to the subscriber server.
  • the replication data received on the subscriber server to be entirely applied.
<Connection variable>.InfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server table.
<Connection variable>.DeleteSchedulingHistory (Function)
Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
<Connection variable>.ExecuteScheduling (Function)
Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
<Connection variable>.ModifyScheduling (Function)
Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
<Connection variable>.DeleteScheduling (Function)
Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
Handling WEBDEV Account Manager via command line
All the features in WEBDEV Account Manager can be used via command line...
<Connection variable>.InfoDatabaseRights (Function)
Gets the rights granted to a user or group on a database.
<Connection variable>.ModifyItemRights (Function)
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table.
<Connection variable>.NotifConfigure (Function)
Specifies and configures the server used to send notifications by the HFSQL server.
<Connection variable>.TransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
<Connection variable>.Backup (Function)
Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more tables.
<Connection variable>.DescribeServerTrigger (Function)
Adds or modifies a server trigger.
FaxCompleteStatus Structure
The FaxCompleteStatus structure is automatically filled during the call to FaxStatus...
<Connection variable>.RestoreBackup (Function)
Used to restore:
  • an immediate backup (performed by HBackup or via the HFSQL Control Center),
  • a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.
<Connection variable>.CopyFile (Function)
Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any):
  • from the HFSQL server to the server (to perform a backup for example).
  • from the HFSQL server to the client (to perform a local backup for example).
  • from the client to the HFSQL server (to update the tables for example).
  • from an HFSQL server to antoher HFSQL server.
Deployment diagram
A deployment diagram shows the physical layout of the hardware components (nodes) used in a system as well as the association between the executable programs and these components...
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<gglConnection variable>.FillCalendarByRequest (Function)
Fills a calendar that was previously retrieved: the events corresponding to the calendar are retrieved via a custom query.
3. UML models in practice
The Image property gets and sets the background image of a control or block.
3. UML models in practice
Deletes a track from a TimeLine control.
Remote deployment via FTP or HTTP
Gets the architecture (32 or 64-bit) of a computer's default email client.
<Connection variable>.SetServer (Function)
Used to find out and modify some settings of HFSQL Client/Server server.
Customizing the WINDEV User Groupware
The User Groupware in automatic mode offers many possibilities...
Brochure des nouveautés 2024 : Nouveautés communes
Nouveautés de WINDEV/WEBDEV/WINDEV Mobile 2024 présentes dans la brochure des Nouveautés 2024.
1
8