PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
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
HInfoFile (Function)
In french: HInfoFichier
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Returns the characteristics of a HFSQL Classic or Client/Server data file.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Recovery of the size of a data file
// by using the current connection of a data file
Trace("Total size of Customer file: " + HInfoFile(Customer, hTotalSize))
// Retrieving the size of a data file 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 a HFSQL Classic data file Hide the details

<Result> = HInfoFile(<Data file> , <Information>)
<Result>: Type of the requested information
Sought information.
<Data file>: Character string (with or without quotes)
Name of the data file to be analyzed.
<Information>: Integer constant
Requested information about the data file:
hFicSizeSize of data file in bytes (".Fic" file).
Versions 14 and later
hFtxSize
New in version 14
hFtxSize
hFtxSize
Size 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 size in bytes of data file (cumulative size of data file, memo file and index file).

Finding out information regarding a 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 (with or without quotes) or Connection variable
Connection to use. This connection corresponds to:
<Data file>: Character string (with quotes)
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).
Versions 14 and later
hFtxSize
New in version 14
hFtxSize
hFtxSize
Size 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 byte size of data file (cumulative size of data file, memo file and index file)
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment