PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • List of functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
Several HFSQL functions are used to manage the HFSQL Client/Server data.
These functions are mainly used to:
  • Manage the users and the groups of users (creation, rights, ...)
  • Manage the data files found on the server
  • Manage the referential integrity (functions for managing the links)
  • Manage the server.
List of functions
The following functions are used to manage the HFSQL Client/Server engine:
HActivateServerTriggerRe-enables a server trigger that was disabled by HDeactivateServerTrigger.
HAddGroupAdds a group of users.
HAddLinkAdds an integrity rule between two data files on the server.
HAddScheduledBackupAdds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
HAddScheduledOptimizationAdds an optimization task of HFSQL Client/Server data files.
HAddSchedulingCreates a scheduled task on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HAddTaskAdds a scheduled task on the server defined by the connection.
HAddUserAdds a user to a database.
HBackupMakes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
HCancelBackupCancels a current backup.
HChangePasswordChanges the password of a HFSQL Classic or HFSQL Client/Server data file.
HCheckServerUpdateChecks where there is a more recent version of the HFSQL server that can be automatically updated.
HClearWorkingDirClears and destroys the temporary directory that was created during the execution of HServerWorkingDir.
HConnectionQualityReturns the quality level of connection: the higher the level is, the faster the connection will be.
HCopyFileCopies a HFSQL file (.fic, .ndx and .mmo files if they exist):
  • 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 a HFSQL server to antoher HFSQL server.
HCreateServerTriggerAdds or modifies a server trigger on the HFSQL server.
HCS.FrameSizeThe HCS.FrameSize variable is used to resize the outgoing data frame.
HCS.TimeoutThe HCS.Timeout variable is used to modify the connection time-out:
  • for the connections established by HOpenConnection.
  • for the automatic connection openings.
HDeactivateServerTriggerDisables a HFSQL Client/Server server trigger on a server.
HDeleteBackupDeletes a backup previously performed by HBackup.
HDeleteDatabaseDeletes a database found on a HFSQL server.
HDeleteDirectoryDeletes a directory found in a HFSQL Client/Server database.
HDeleteFileDeletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
HDeleteGroupDeletes (from the server) a group of users associated with a connection.
HDeleteLinkDeletes an integrity rule between two data files on the server.
HDeleteParameterDeletes a parameter that was saved beforehand by HSaveParameter.
HDeleteQueryDeletes a query (used by stored procedures) from a HFSQL server.
HDeleteScheduledBackupDeletes a scheduling for backup from a HFSQL Client/Server server.
HDeleteScheduledOptimizationDeletes a scheduled optimization task of HFSQL Client/Server data files.
HDeleteSchedulingDeletes a scheduled task found on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HDeleteServerTriggerDestroys a server trigger.
HDeleteSetDeletes a set of stored procedures from a HFSQL server.
HDeleteTaskDeletes a scheduled task from a HFSQL Client/Server server.
HDeleteUserDeletes (fro the server) a user associated with a connection.
HDescribeServerTriggerAdds or modifies a server trigger.
HDisconnectClientDisplays a message on the client computers and disconnects the application.
HDuplicateDatabaseDuplicates the database associated with a connection on a HFSQL server.
HEndNoDatabaseAccessRe-allows the access (which means the connection) to one or more databases accessible via a connection.
HExecuteProcedureRuns a stored procedure.
HExecuteScheduledBackupForces the execution of a scheduled backup.
HExecuteSchedulingImmediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HInfoBackupReturns information about one or more backups performed on an HFSQL Client/Server server.
HInfoDatabasePropertyUsed to find out the properties of a database found on a HFSQL server.
HInfoDatabaseRightsAllows you to find out the rights granted to a user or to a group on a database.
HInfoFilePropertyAllows you to find out the properties of a data file located in an HFSQL server.
HInfoFileRightsAllows you to find out the rights granted to a user or to a group on a HFSQL Client/Server data file.
HInfoGroupReturns information about the specified group of users.
HInfoLockReturns information about the lock performed on a data file, on a record or on all the records found in a data file.
HInfoLogReturns information about the server logs.
HInfoServerReturns the specified information about the server.
HInfoServerPropertyAllows you to find out the properties of an HFSQL server.
HInfoServerRightsAllows you to find out the rights granted to a user or group of users on a server.
HInfoTaskReturns the characteristics of a scheduled task in a hScheduledTask variable].
HInfoUserUpdates the variables for user management with the information regarding the specified user.
HInfoViewReturns information about a materialized view.
HInfoViewRightsAllows you to find out the rights granted to a user or to a group on a SQL view or on a materialized view.
HListConnectedUserLists the users currently connected to one or more files handled by a Client/Server connection.
HListDatabaseLists the Client/Server databases associated with a connection.
HListGroupReturns the list of groups of users defined for a connection.
HListParameterReturns the list of parameters saved from the stored procedures on the server.
HListScheduledBackupLists the full and differential backups that have been scheduled on a HFSQL Client/Server server.
HListScheduledOptimizationLists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
HListSchedulingLists the scheduled tasks defined on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HListServerLists the HFSQL servers installed on a computer.
HListServerTriggerLists the different triggers available on a connection or on one of the connection files.
HListStoredElementReturns the list of elements stored on a HFSQL server (sets of procedures, stored procedures or queries).
HListTaskReturns the list of scheduled tasks found on a HFSQL Client/Server server for a given connection.
HListUserReturns the list of users defined for a connection.
HLoadParameterReads a parameter that was saved from a stored procedure by HSaveParameter.
HManageServerUpdateUsed to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
HManageTaskEnables or disables a scheduled task on a HFSQL Client/Server server.
HModifyDatabasePropertyModifies the properties of a database found on a HFSQL server.
HModifyDatabaseRightsModifies the rights granted to a user or to a group for a HFSQL Client/Server database.
HModifyFilePropertyModifies the properties of a HFSQL file found on a server.
HModifyFileRightsModifies the rights granted to a user or to a group on a HFSQL Client/Server data file.
HModifyGroupModifies the group information according to the elements found in the corresponding variables for group management.
HModifyScheduledBackupModifies a backup scheduling.
HModifyScheduledOptimizationModifies a scheduled optimization task on the HFSQL server defined by the connection.
HModifySchedulingModifies a scheduled task on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
HModifyServerPropertyModifies the properties of a HFSQL server.
HModifyServerRightsModifies the rights granted to a user or to a group on a HFSQL server.
HModifyTaskModifies a scheduled task on the HFSQL server defined by the connection.
HModifyUserModifies the information about a user according to the elements found in the corresponding variables for user management.
HModifyViewRightsModifies the rights granted to a user or to a group on a SQL view or on a materialized view.
HNoDatabaseAccessDenies all new connections to a database or to all databases.
HNotifAddCCRecipientAdds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
HNotifAddEmailRecipientAdds recipients for the notifications sent by email.
HNotifConfigureSpecifies and configures the server used to send notifications by the HFSQL server.
HNotifDeleteCCRecipientDeletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
HNotifDeleteEmailRecipientDeletes the recipients of a notification by email.
HNotifListCCRecipientReturns the list of recipients for a notification sent via the Control Centers (WDBal messaging tool).
HNotifListEmailRecipientReturns the list of recipients for a notification by email.
HOnServerCallCustomizes the management of message display on the client computer and the management of disconnection from a client computer.
HOperationInProgressReturns the list of automatic operations in progress on a HFSQL server.
HPriorityUsed to find out and modify the priority of the calling application.
HPriorityClientModifies the priority of a client application.
HReconnectPerforms a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified.
HRefreshQueryCreates or refreshes a query on a HFSQL server.
HRefreshSetCreates or updates a set of procedures on a HFSQL server.
HResetClientInitializes the structure for managing the Client computers (HClient structure]).
HResetGroupInitializes the structure for group management (HGroup) with the default values.
HResetUserInitializes the structure for user management (HUser) with the default values.
HRestoreBackupUsed 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.
HRetrieveBackupRetrieves locally the content of a compressed backup (in ZIP format) performed on a HFSQL server.
HRetrieveLogCreates a text file containing the server logs between two given dates.
HSaveParameterSaves a persistent value on the HFSQL server.
HSendMessageToClientDisplays a message on the client computers.
HServerMaintenanceChecks and optimizes the system tables of a HFSQL server.
HServerStatusAllows you to find out the status of a HFSQL server (this function uses the MantaManager service).
HServerWorkingDirReturns the path of a temporary directory on the HFSQL server.
HSetCacheUsed to configure the management of caches in the HFSQL Client/Server engine.
HSetServerUsed to find out and modify some settings of HFSQL Client/Server server.
HSimulateNetworkSimulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
HStartServerAllows you to start a HFSQL server (this function is using the MantaManager service).
HStartServerUpdateUsed to immediately start the automatic server update.
HStopServerStops a HFSQL server.
HTrackStarts tracking the write actions (addition, modification or deletion) performed on a file found on a HFSQL server.
HTrackStopStops tracking a data file on a HFSQL server.
HTransactionIsolationConfigures the isolation mode of transactions for a connection to a HFSQL server.
HTransactionListReturns the list of current or interrupted transactions found on the server for the specified connection.
Versions 25 and later
HUpdateLink
New in version 25
HUpdateLink
HUpdateLink
Updates on the server all the links of an HFSQL Client/Server data file.
HUpdateViewCreates or updates the description of a SQL view or materialized view from the analysis to a HFSQL server.
Related Examples:
The HSetServer function Unit examples (WINDEV): The HSetServer function
[ + ] Using the HSetServer of WINDEV.
This function is used to modify some parameters on the HFSQL server.
It allows you to configure your server more efficiently.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment