ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2024
Category: HFSQL Client/Server functions
244 results
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
Adds a group of users.
Adds an integrity rule between two files on the server.
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
Adds an optimization task of HFSQL Client/Server data files.
Creates a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Adds a scheduled task on the server defined by the connection.
Adds a user to a database.
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
Cancels a current backup.
Checks for the latest version of the HFSQL server that can be automatically updated.
Returns the quality level of connection: the higher the level is, the faster the connection will be.
Copies an HFSQL data file (.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 data files for example).
  • from an HFSQL server to antoher HFSQL server.
Disables a HFSQL Client/Server server trigger on a server.
Deletes a backup previously created with HBackup.
Deletes a database located on an HFSQL server.
Deletes a directory from an HFSQL Client/Server database.
Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
Deletes (from the server) a group of users associated with a connection.
Deletes an integrity rule between two data files on the server.
Deletes a parameter previously saved by HSaveParameter.
Deletes a query (used by stored procedures) from an HFSQL server.
Deletes a scheduled backup from an HFSQL Client/Server server.
Deletes a scheduled optimization task from HFSQL Client/Server data files.
Deletes a scheduled task found on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Deletes a server trigger.
Deletes a set of stored procedures from an HFSQL server.
Deletes a scheduled task from an HFSQL Client/Server server.
Deletes a user associated with a connection to the HFSQL server.
Adds or modifies a server trigger.
Displays a message on the Client computer(s) and disconnects the application.
Deletes a materialized view from the HFSQL server.
Duplicates the database associated with a connection on an HFSQL server.
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
Runs a stored procedure.
Forces the execution of a scheduled backup.
Immediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Returns information about one or more backups performed on an HFSQL Client/Server server.
Used to find out the properties of a database on an HFSQL server.
Allows you to find out the rights granted to a user or to a group on a database.
Allows you to find out the properties of a data file located in an HFSQL server.
Allows you to find out the rights granted to a user or to a group on an HFSQL Client/Server data file.
Returns information about the specified group of users.
Returns information about the lock set on a data file, on one or all the records in a data file.
Returns the specified information about the server.
Allows you to find out the properties of an HFSQL server.
Allows you to find out the rights granted to a user or group of users on a server.
Returns the characteristics of a scheduled task in a hScheduledTask variable].
Updates the variables for user management with the information regarding the specified user.
Returns information about a materialized view.
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.
Lists the Client/Server databases associated with a connection.
Returns the list of groups of users defined for a connection.
Returns the list of parameters saved from the stored procedures on the server.
Lists the full and differential backups that have been scheduled on HFSQL Client/Server.
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Lists the scheduled tasks defined on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
Returns the list of users defined for a connection.
Returns the list of files watched by HWatch.
Reads a parameter that was saved from a stored procedure by HSaveParameter.
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
Enables or disables a scheduled task on an HFSQL Client/Server server.
Modifies the properties of a database located on an HFSQL server.
Modifies the rights granted to a user or to a group for a HFSQL Client/Server database.
Modifies the properties of an HFSQL data file located on a server.
Modifies the rights granted to a user or group on an HFSQL Client/Server data file.
Modifies the group information according to the elements found in the corresponding variables for group management.
Modifies a backup scheduling.
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
Modifies a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Modifies the properties of an HFSQL server.
Modifies the rights granted to a user or to a group on a HFSQL server.
Modifies a scheduled task on the HFSQL server defined by the connection.
Modifies the information about a user according to the elements found in the corresponding variables for user management.
Modifies the rights granted to a user or group on an SQL view or on a materialized view.
Denies all new connections to a database or to all databases.
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
Adds recipients for the notifications sent by email.
Specifies and configures the server used to send notifications by the HFSQL server.
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
Deletes the recipients of an email notification.
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
Returns the list of recipients for a notification by email.
Returns the list of automatic operations in progress on an HFSQL server.
Finds out and modifies the priority of the calling application.
Modifies the priority of a client application.
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.
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
Creates a text file containing the server logs between two given dates.
Saves a persistent value on the HFSQL server.
Displays a message on the client computers.
Checks and optimizes the system tables of an HFSQL server.
Used to find out and modify some settings of HFSQL Client/Server server.
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
Used to immediately start the automatic server update.
Stops an HFSQL server.
Configures the isolation mode of transactions for a connection to an HFSQL server.
Returns the list of current or interrupted transactions on the server for the specified connection.
Rolls the transaction back to the savepoint.
Declares a transaction savepoint.
Creates or updates a query on an HFSQL server.
Creates or updates a set of procedures on an HFSQL server.
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
Changes the password of an HFSQL Classic or HFSQL Client/Server data file.
Returns information about the lock set on a data file, on one or all the records in a data file.
Updates on the server all the links of an HFSQL Client/Server data file.
Starts watching write actions (add, modify or delete) performed on a file in an HFSQL server.
Stops watching a data file on an HFSQL server.
Adds a group of users.
Adds an integrity rule between two data files on the server.
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
Adds an optimization task of HFSQL Client/Server data files.
Creates a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Adds a scheduled task on the server defined by the connection.
Adds a user to a database.
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
Cancels a current backup.
Changes the password of an HFSQL Classic or HFSQL Client/Server data file.
Checks for the latest version of the HFSQL server that can be automatically updated.
Clears and destroys the temporary directory previously created when HServerWorkingDir was executed.
Returns the quality level of connection: the higher the level is, the faster the connection will be.
Usage example of the HCopyFile function
Copies an HFSQL data file (.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 data files for example).
  • from an HFSQL server to antoher HFSQL server.
The HCS.FrameSize variable is used to resize the outgoing data frame.
The HCS.Timeout variable is used to modify the connection timeout:
  • for the connections established by HOpenConnection.
  • for the automatic connection openings.
Deletes a backup previously created with HBackup.
Deletes a database located on an HFSQL server.
Deletes a directory from an HFSQL Client/Server database.
Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
Deletes (from the server) a group of users associated with a connection.
Deletes an integrity rule between two data files on the server.
Deletes a parameter previously saved by HSaveParameter.
Deletes a query (used by stored procedures) from an HFSQL server.
Deletes a scheduled backup from an HFSQL Client/Server server.
Deletes a scheduled optimization task from HFSQL Client/Server data files.
Deletes a scheduled task found on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Deletes a set of stored procedures from an HFSQL server.
Deletes a scheduled task from an HFSQL Client/Server server.
Deletes a user associated with a connection to the HFSQL server.
Displays a message on the Client computer(s) and disconnects the application.
Deletes a materialized view from the HFSQL server.
Duplicates the database associated with a connection on an HFSQL server.
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
Runs a stored procedure.
Forces the execution of a scheduled backup.
Immediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Returns information about one or more backups performed on an HFSQL Client/Server server.
Used to find out the properties of a database on an HFSQL server.
Usage example of HInfoDatabaseRights
Allows you to find out the rights granted to a user or to a group on a database.
Allows you to find out the properties of a data file located in an HFSQL server.
Usage example of the HInfoFileRights function
Allows you to find out the rights granted to a user or to a group on an HFSQL Client/Server data file.
Returns information about the specified group of users.
Allows you to find out which rights have been granted to a section.
Returns information about the lock set on a data file, on one or all the records in a data file.
Returns information about the server logs.
Returns the specified information about the server.
Allows you to find out the properties of an HFSQL server.
Usage example of the HInfoServerRights function
Allows you to find out the rights granted to a user or group of users on a server.
Returns the characteristics of a scheduled task in a hScheduledTask variable].
Updates the variables for user management with the information regarding the specified user.
Returns information about a materialized view.
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.
Lists the users currently connected to one or more files handled by a Client/Server connection.
Lists the Client/Server databases associated with a connection.
Returns the list of groups of users defined for a connection.
Returns the list of parameters saved from the stored procedures on the server.
Lists the full and differential backups that have been scheduled on HFSQL Client/Server.
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Lists the scheduled tasks defined on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Lists the HFSQL servers installed on a computer.
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
Returns the list of users defined for a connection.
Returns the list of files watched by HWatch.
Reads a parameter that was saved from a stored procedure by HSaveParameter.
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
Enables or disables a scheduled task on an HFSQL Client/Server server.
Modifies the properties of a database located on an HFSQL server.
Modifies the rights granted to a user or to a group for a HFSQL Client/Server database.
Modifies the properties of an HFSQL file located on a server.
Modifies the rights granted to a user or group on an HFSQL Client/Server data file.
Modifies the group information according to the elements found in the corresponding variables for group management.
Modifies the rights granted on an a data file HFSQL Client/Server item for a user or group.
Modifies a backup scheduling.
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
Modifies a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Modifies the properties of an HFSQL server.
Modifies the rights granted to a user or to a group on an HFSQL server.
Modifies a scheduled task on the HFSQL server defined by the connection.
Modifies the information about a user according to the elements found in the corresponding variables for user management.
Modifies the rights granted to a user or to a group on a SQL view or on a materialized view.
Denies all new connections to a database or to all databases.
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
Adds recipients for the notifications sent by email.
Specifies and configures the server used to send notifications by the HFSQL server.
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
Deletes the recipients of an email notification.
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
Returns the list of recipients for a notification by email.
Customizes the management of message display on the client computer and the management of disconnection from a client computer.
Returns the list of automatic operations in progress on an HFSQL server.
Finds out and modifies the priority of the calling application.
Modifies the priority of a client application.
Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified.
Initializes the structure for managing the Client computers (HClient structure).
Initializes the structure for group management (HGroup) with the default values.
Initializes the structure for user management (HUser) with the default values.
Usage example of the HRestoreBackup 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.
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server.
Creates a text file containing the server logs between two given dates.
Saves a persistent value on the HFSQL server.
Displays a message on the client computers.
Checks and optimizes the system tables of an HFSQL server.
The hServerOperation type is used to get the characteristics of an operation performed on an HFSQL server.
Allows you to find out the status of a HFSQL server (this function uses the MantaManager service).
Returns the path of a temporary directory on the HFSQL server.
Used to configure the management of caches in the HFSQL Client/Server engine.
Used to find out and modify some settings of HFSQL Client/Server server.
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
Allows you to start an HFSQL server (this function is using the MantaManager service).
Used to immediately start the automatic server update.
Stops an HFSQL server.
Returns a list of keys to add to data files to improve query performance.
Finishes collecting information on executed queries.
Starts collecting information on executed queries.
Rolls the transaction back to the savepoint.
Declares a transaction savepoint.
Updates on the server all the links of an HFSQL Client/Server data file.
Creates or updates a query on an HFSQL server.
Creates or updates a set of procedures on an HFSQL server.
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
Starts watching write actions (add, modify or delete) performed on a file in an HFSQL server.
Stops watching a data file on an HFSQL server.
Allows you to find out which rights have been granted to a section.
Modifies the rights granted on an a data file HFSQL Client/Server item for a user or group.
1 document