PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
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.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Example
Trace(HInfoServer("MyConnection", hInfoHardware))
// Returns "Intel Pentium" + TAB + "639MB" + CR
Syntax
<Result> = HInfoServer(<Connection Name> [, <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 Name>: Character string (with or without quotes)
Name of the connection for which the information regarding the server must be retrieved. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
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.
Versions 15 and later
hInfoCluster
New in version 15
hInfoCluster
hInfoCluster
Information 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".
Versions 22 and later
hInfoFreeDiskSpace
New in version 22
hInfoFreeDiskSpace
hInfoFreeDiskSpace
Available space on the server disk, expressed in MB.
AndroidAndroid Widget Java Not available.
Versions 22 and later
hInfoTotalDiskSpace
New in version 22
hInfoTotalDiskSpace
hInfoTotalDiskSpace
Total capacity of server disk, expressed in MB.
AndroidAndroid Widget Java Not available.
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>
hInfoNameName of server (DNS)
hInfoLogicalNameName of the server given in the HFConf.ini file or specified during the setup. This name appears in the HFSQL Control Center.
hInfoPlatformInformation about the server platform:
  • Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX, Windows Vista, Windows Vista (64 bits)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.
    • LINUXLINUX 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>
Versions 19 and later
hInfoSizeCacheNdxUsed
New in version 19
hInfoSizeCacheNdxUsed
hInfoSizeCacheNdxUsed
Size of index cache that is actually used on the server, expressed in MB.
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).
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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • 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
Dec. 04 2016