ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HInfoServer (Function)
In french: HInfoServeur
HFSQL Client/ServerAvailable only with this kind of connection
Returns the specified information about the server. The server corresponds to the computer on which the connection is established.
Example
Trace(HInfoServer("MaConnexion", hInfoHardware))
// Renvoie "Intel Pentium" + TAB + "639Mo" + RC
Syntax
<Result> = HInfoServer(<Connection> [, <Type of information>])
<Result>: Character string
Requested information. If several types of information are requested, each type of information is separated by a CR character (Carriage Return).
The order in which the information is returned (if requested) is as follows:
hInfoVI + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate
<Connection>: Character string or Connection variable
Connection for which server computer information must be retrieved. This connection corresponds to: A WLanguage error occurs if the specified name does not exist.
<Type of information>: Optional constant (or combination of constants)
Requested type of information. The result depends on the type of requested information.
hInfoAll
(Default value)
Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate).
The different values are separated by CR characters (Carriage Return).
hInfoClusterInformation about the HFSQL Client/Server cluster, in the following format:
<Name of cluster manager> + CR + <List of cluster nodes>.

The list of cluster nodes has the following format:
<Node name> + <TAB> + <Node status> + TAB + <Version>.
The states of the node can be:
  • 0: Node not part of the cluster.
  • 1: Knot stopped.
  • 2: Node waiting to start.
  • 3: Node starting up
  • 4: Node waiting for synchronization source.
  • 5: Node being synchronized.
  • 6: Active node.
  • 7: Node stopped.
  • 8: Status unknown.
hInfoDateDate and time of server on 8 bytes in UTC format (universal time). This information is a character string of the type "YYYYMMDDHHmmSS".
hInfoFreeDiskSpaceAvailable space on the server disk, expressed in bytes.
hInfoHardwareInformation about the hardware used:
  • Processor type (example: Intel Pentium).
  • Server RAM size (example: 630MB)
This information is returned in the following format:
<Type of CPU> = TAB + <Size of server RAM>
hInfoLogicalNameName of the server given in the HFConf.ini file or specified during the setup. This name appears in the HFSQL Control Center.
hInfoNameName of server (DNS)
hInfoPlatformInformation about the server platform:
  • Name of operating system:
    • Windows Windows Vista, Windows Vista (64 bits), Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 2008, Windows 2008 R2, Windows 2012, Windows 2012 R2.
    • LINUX followed by the distribution name. For example: "LINUX Ubuntu 14"
  • System version: corresponds to the Windows service pack, or empty string if no service pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example).
This information is returned in the following format:
<System name> + TAB + <Version>
hInfoSizeCacheNdxUsedSize of index cache that is actually used on the server, expressed in MB.
hInfoTotalDiskSpaceTotal capacity of server disk, expressed in bytes.
hInfoVersionInformation about the version of programs required for the server to operate:
  • Version of Manta.exe or Manta in Linux
  • Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
  • Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
  • Version of log manager (HFLogger.exe)
  • Version of Framework
  • 32/64
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> + TAB + <SQL version> + TAB + <Log version> + TAB + <Framework version> + TAB + <32/64>
hInfoVersionDetailsDetailed information about the version of the programs required to operate the server:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date>
The listed elements are as follows:
  • Manta.exe or Manta in Linux
  • HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
  • SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
  • Management of logs (HFLogger.exe)
  • MantaManager
  • the framework required to operate the server.
This information is returned in the following format:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date> + TAB + <File time>
hInfoVIVersion number of Manta.exe or Manta in Linux.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Exemplo HinfoServer
trace(HInfoServer("Matos_Hyperfile_server",hInfoDate)

s_hInfoHardware is string=HInfoServer("Matos_hyperfil_server", hInfoHardware)
s_hInfoName is string=HInfoServer("Matos_hyperfil_server", hInfoName)
s_hInfoSizeCacheNdxUsed is string=HInfoServer("Matos_hyperfil_server", hInfoSizeCacheNdxUsed)
s_hInfoPlatform is string=HInfoServer("Matos_hyperfil_server", hInfoPlatform)
s_hInfoLogicalName is string=HInfoServer("Matos_hyperfil_server", hInfoLogicalName)
s_hInfoVersion is string=HInfoServer("Matos_hyperfil_server", hInfoVersion)

//Blog com Video e Exemplo

http://windevdesenvolvimento.blogspot.com.br/2016/11/aula-971-windev-hyperfile-26-hinfoserver.html

https://www.youtube.com/watch?v=TS_mbRJGeSY


De matos
04 Dec. 2016

Last update: 06/12/2025

Send a report | Local help