ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL 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
Returns the characteristics of an HFSQL Classic or Client/Server data file.
Example
// Get the size of a data file
// by using the current connection of a data file
Trace("Total size of Customer file: " + HInfoFile(Customer, hTotalSize))
// Get the size of a data file by using a connection
 
// Connection parameters
CntTest is Connection
CntTest.Provider = hAccessHFClientServer
CntTest.User = "admin"
CntTest.Password = "pass_admin"
CntTest.Server = "server:4930"
CntTest.Database = "TestDatabase"
 
Trace("Total size of Customer file: " + ...
HInfoFile(CntTest.Name, "FileName.FIC", hTotalSize))
Syntax

Finding out information regarding an HFSQL Classic data file Hide the details

<Result> = HInfoFile(<Data file> , <Information>)
<Result>: Type of the requested information
Sought information.
<Data file>: Character string
Name of the data file to analyze.
<Information>: Integer constant
Requested information about the data file:
hFicSizeSize of data file in bytes (".Fic" file).
hFtxSizeSize of full-text index file in bytes (".Ftx" file).
hMmoSizeSize of memo file in bytes (".Mmo" file).
hNdxSizeSize of index file in bytes (".Ndx" file).
hTotalSizeTotal data file size in bytes (cumulative size of data file, memo file and index file).

Finding out information regarding an HFSQL Client/Server data file Hide the details

<Result> = HInfoFile(<Connection> , <Data file> , <Information>)
<Result>: Type of the requested information
  • Requested information,
  • 0 if the connection exists but the data file is not found on the drive.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Data file>: Character string
Physical name of the data file to analyze.
<Information>: Integer constant
Requested information about the data file:
hFicSizeSize of data file in bytes (".Fic" file).
hFtxSizeSize of full-text index file in bytes (".Ftx" file).
hMmoSizeSize of memo file in bytes (".Mmo" file).
hNdxSizeSize of index file in bytes (".Ndx" file).
hTotalSizeTotal data file size in bytes (cumulative size of data file, memo file and index file).
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help