ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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("MyConnection", hInfoHardware))
// Return "Intel Pentium" + TAB + "639MB" + CR
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:
<Cluster name> + TAB + <Node status> + TAB + <Version>.
The states of the node can be:
  • 0: Node not belonging to the cluster.
  • 1: Node stopped.
  • 2: Node waiting to be started.
  • 3: Node being started
  • 4: Node waiting for source of synchronization.
  • 5: Node currently synchronized.
  • 6: Node enabled.
  • 7: Node being stopped.
  • 8: Unknown status.
hInfoDateDate and time of server on 8 bytes in UTC format (universal time). This information is a character string in the following format: "YYYYMMDDHHmmSS".
hInfoFreeDiskSpaceAvailable space on the server disk, expressed in bytes.
hInfoHardwareInformation about the hardware used:
  • Type of processor (for example: Intel Pentium).
  • Size of server RAM (for example: 630 MB)
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 Service Pack in Windows 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: wd290hf.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: 05/26/2022

Send a report | Local help