PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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 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 a materialized view.
HAddTaskAdds a scheduled task on the server defined by the connection.
HAddUserAdds a user to a database.
HBackupSaves the content of a HFSQL server: all databases found 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 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.
HDeactivateServerTriggerDisables a HFSQL Client/Server server trigger on a server.
HDeleteBackupDeletes a backup that was 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 a 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.
HDescribeServerTriggerAdds or modifies a server trigger.
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 a 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.
HInfoFilePropertyUsed to find out the properties of a data file found on a 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.
HInfoServerPropertyUsed to find out the properties of a HFSQL server.
HInfoServerRightsAllows you to find out the rights granted to a user or to a group 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 a materialized view.
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 a 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.
HModifyViewRightsModifies the rights granted to a user or to a group on a SQL view or on a materialized view.
HNoDatabaseAccessForbids 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 from a stored procedure.
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.
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.
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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment