PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
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
<Connection variable>.InfoServer (Function)
In french: <Variable Connexion>.InfoServeur
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 iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for 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.
Remark: 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.
Android This function is now available for Android applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
Example
// Describe the connection
MyConnection is Connection
 
Trace(MyConnection.InfoServer(hInfoHardware))
// Return "Intel Pentium" + TAB + "639MB" + CR
Syntax
<Result> = <Connection>.InfoServer([<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>: Connection variable
Name of the Connection variable that describes the connection for which the server computer information must be retrieved.
<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 bytes.
Versions 22 and later
hInfoTotalDiskSpace
New in version 22
hInfoTotalDiskSpace
hInfoTotalDiskSpace
Total capacity of 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>
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 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>
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.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment