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
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.
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
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
// Retrieve the size of a file
// by using the current connection of a file
Trace("Total size of Customer file: " + HInfoFile(Customer, hTotalSize))
// Retrieve the size of a 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 a HFSQL Classic data file Hide the details

<Result> = HInfoFile(<File Name> , <Information>)
<Result>: Type of the requested information
Sought information.
<File Name>: Character string (with or without quotes)
Logical 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 file size in bytes (added 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 Name> , <File Name> , <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 Name>: Character string (with or without quotes)
Name of the connection, defined in the data model editor or by HDescribeConnection or HOpenConnection.
<File Name>: 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 file size in bytes (added size of data file, memo file and index file).
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
Click [Add] to post a comment