|
|
|
|
|
|
|
Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Allows you to find out the properties of an HFSQL server. |
|
|
|
|
|
|
WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
Creates a connection to OneDrive. |
|
|
|
|
|
|
Re-allows the access (which means the connection) to one or more databases accessible via a connection. |
|
|
|
|
|
|
Returns the list of users defined for a connection. |
|
|
|
|
|
|
Displays a message on the client computers. |
|
|
|
|
|
|
The hbColumn type is used to define the advanced characteristics of a column (item) in an HBase table. |
|
|
|
|
|
|
The Connection property gets and sets the connection associated with a table. |
|
|
|
|
|
|
Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
Lists the replications available on a master HFSQL server. |
|
|
|
|
|
|
Performs a search among the records found in a Salesforce database. |
|
|
|
|
|
|
Modifies the properties of an HFSQL server. |
|
|
|
|
|
|
Adds an integrity rule between two files on the server. |
|
|
|
|
|
|
Modifies the priority of a client application. |
|
|
|
|
|
|
Deletes records from a Salesforce database. |
|
|
|
|
|
|
Creates a record in a file of a Salesforce database. |
|
|
|
|
|
|
Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
Finds out and modifies the priority of the calling application. |
|
|
|
|
|
|
Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
Seeks and retrieves the records (Salesforce objects) modified during the specified period. |
|
|
|
|
|
|
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. |
|
|
|
|
|
|
Retrieves the Salesforce records from their identifiers. |
|
|
|
|
|
|
Clears the specified records from the Salesforce recycle bin. |
|
|
|
|
|
|
Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. |
|
|
|
|
|
|
Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
Returns the list of automatic operations in progress on an HFSQL server. |
|
|
|
|
|
|
Modifies the properties of a database located on an HFSQL server. |
|
|
|
|
|
|
Reads one or more registers from a Modbus slave, starting at a specific address. |
|
|
|
|
|
|
Reads one or more bits from a Modbus slave, starting at a specific address. |
|
|
|
|
|
|
The SAP variable is used to configure the parameters of the connection to the SAP server... |
|
|
|
|
|
|
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
Writes one or multiple bits to a specific address in a Modbus slave. |
|
|
|
|
|
|
Refreshes a user's OAuth2 token when it expires. |
|
|
|
|
|
|
Refreshes a user's OAuth2 token when it expires. |
|
|
|
|
|
|
Duplicates the database associated with a connection on an HFSQL server. |
|
|
|
|
|
|
Returns the list of tables watched by HWatch. |
|
|
|
|
|
|
Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL server. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Returns information about a materialized view. |
|
|
|
|
|
|
Closes the Modbus session. |
|
|
|
|
|
|
Deletes a scheduled optimization task from HFSQL Client/Server tables. |
|
|
|
|
|
|
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Writes one or more registers (16-bit values) to a Modbus slave, starting at a specific address. |
|
|
|
|
|
|
Cancels a current backup. |
|
|
|
|
|
|
Deletes a scheduled backup from an HFSQL Client/Server server. |
|
|
|
|
|
|
Deletes a query (used by stored procedures) from an HFSQL server. |
|
|
|
|
|
|
Used to immediately start the automatic server update. |
|
|
|
|
|
|
The Drive type is used to handle online storage services. To use this type of variable, you need to connect to the desired service. |
|
|
|
|
|
|
Closes a connection to a database. |
|
|
|
|
|
|
Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Declares a transaction savepoint. |
|
|
|
|
|
|
Modifies a backup scheduling. |
|
|
|
|
|
|
Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
Executes a stored procedure in asynchronous mode. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Allows you to find out the properties of a table located in an HFSQL server. |
|
|
|
|
|
|
Returns the quality level of the connection: the higher the level is, the faster the connection is. |
|
|
|
|
|
|
Adds a user to a database. |
|
|
|
|
|
|
Adds an optimization task of HFSQL Client/Server tables. |
|
|
|
|
|
|
Modifies the properties of an HFSQL table located on a server. |
|
|
|
|
|
|
Adds recipients for the notifications sent by email. |
|
|
|
|
|
|
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection. |
|
|
|
|
|
|
Adds a replication between two HFSQL server onto the master server. |
|
|
|
|
|
|
WLanguage offers several functions for manipulating a Bitcoin Core server... |
|
|
|
|
|
|
If a transaction is in progress, rolls back all operations performed on tables in transactions since the start of the transaction. |
|
|
|
|
|
|
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
|
|
|
|
|
|
Returns the characteristics of an HFSQL Classic or Client/Server table. |
|
|
|
|
|
|
Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
Returns information about the specified group of users. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
Gets the security policy of an HFSQL server.This new function is available from version 2025 Update 3. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Deletes a database located on an HFSQL server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Enables or disables a scheduled task on an HFSQL Client/Server server. |
|
|
|
|
|
|
Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
Reads the replication configuration for an HFSQL server that takes part in one or more replications. |
|
|
|
|
|
|
Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
Forces the execution of a scheduled backup. |
|
|
|
|
|
|
Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
Modifies some parameters of an existing replication between two HFSQL servers. |
|
|
|
|
|
|
Deletes a server trigger. |
|
|
|
|
|
|
Downloads a document from Google Docs. |
|
|
|
|
|
|
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
|
|
|
|
|
|
Modifies a scheduled task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Returns the specified information about the server. |
|
|
|
|
|
|
A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
Deletes a scheduled task from an HFSQL Client/Server server. |
|
|
|
|
|
|
Returns the list of current or interrupted transactions on the server for the specified connection. |
|
|
|
|
|
|
Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
Deletes an integrity rule between two tables on the server. |
|
|
|
|
|
|
Usage example of the HDeclareExternal function |
|
|
|
|
|
|
The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc. |
|
|
|
|
|
|
Deletes a replication between two HFSQL servers. |
|
|
|
|
|
|
Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
Configures an HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers. |
|
|
|
|
|
|
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
|
|
|
|
|
|
Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
Returns information about one or more backups performed on an HFSQL Client/Server server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
|
|
|
|
|
|
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an item. |
|
|
|
|
|
|
Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
Checks for the latest version of the HFSQL server that can be automatically updated. |
|
|
|
|
|
|
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
|
|
|
|
|
|
Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Regenerates a table from its log.
|
|
|
|
|
|
|
Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
|
|
|
|
|
|
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL Client/Server table. |
|
|
|
|
|
|
Immediately execute periodic replication between HFSQL servers: replication is triggered ahead of schedule. |
|
|
|
|
|
|
WLanguage procedure (also called "callback") called by the ShareProximityAttendConnection function to notify the connection status with a remote device.t |
|
|
|
|
|
|
Opens a connection to a specific database. |
|
|
|
|
|
|
Deletes a materialized view from the HFSQL server. |
|
|
|
|
|
|
Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
Gets the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
Deletes the recipients of an email notification. |
|
|
|
|
|
|
Used to declare a list of variables whose value will be persistent between the successive calls to a web service. |
|
|
|
|
|
|
Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Gets the rights granted to a user or group on an HFSQL Client/Server table. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
All the features in WEBDEV Account Manager can be used via command line... |
|
|
|
|
|
|
Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table. |
|
|
|
|
|
|
Specifies and configures the server used to send notifications by the HFSQL server. |
|
|
|
|
|
|
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table. |
|
|
|
|
|
|
Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more tables. |
|
|
|
|
|
|
Adds or modifies a server trigger. |
|
|
|
|
|
|
The FaxCompleteStatus structure is automatically filled during the call to FaxStatus... |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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... |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Fills a calendar that was previously retrieved: the events corresponding to the calendar are retrieved via a custom query. |
|
|
|
|
|
|
The Image property gets and sets the background image of a control or block. |
|
|
|
|
|
|
Deletes a track from a TimeLine control. |
|
|
|
|
|
|
Gets the architecture (32 or 64-bit) of a computer's default email client. |
|
|
|
|
|
|
Used to find out and modify some settings of HFSQL Client/Server server. |
|
|
|
|
|
|
The User Groupware in automatic mode offers many possibilities... |
|
|
|
|
|
|
Nouveautés de WINDEV/WEBDEV/WINDEV Mobile 2024 présentes dans la brochure des Nouveautés 2024. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|