Returns the characteristics of an HFSQL Classic or Client/Server data file.
// 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: | |
| hFicSize | Size of data file in bytes (".Fic" file). |
| hFtxSize | Size of full-text index file in bytes (".Ftx" file). |
| hMmoSize | Size of memo file in bytes (".Mmo" file). |
| hNdxSize | Size of index file in bytes (".Ndx" file). |
| hTotalSize | Total 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: | |
| hFicSize | Size of data file in bytes (".Fic" file). |
| hFtxSize | Size of full-text index file in bytes (".Ftx" file). |
| hMmoSize | Size of memo file in bytes (".Mmo" file). |
| hNdxSize | Size of index file in bytes (".Ndx" file). |
| hTotalSize | Total data file size in bytes (cumulative size of data file, memo file and index file). |