ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server 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
Allows you to find out the properties of a data file located in an HFSQL server.
Example
// Describe the connection
HDescribeConnection("MyConnection", "Julia", "Password", ...
"MyHFServer", "MyDatabase", ...
hAccessHFClientServer, hORead)
// Open the connection
HOpenConnection("MyConnection")
...
OwnerName is string
OwnerName = HInfoFileProperty("MyConnection", hOwner, ...
"MyDatabase", "Customer.fic")
IF OwnerName <> "" THEN
Trace("Owner of the database: " + OwnerName)
END
Syntax
<Result> = HInfoFileProperty(<Connection> , <Property> , <Database> , <Data file>)
<Result>: Character string
  • Value of requested property,
  • Empty string ("") if an error occurred.
<Connection>: Character string or Connection variable
Connection for which a property value is requested. This connection corresponds to:
<Property>: Integer constant
Requested file property:
hApplicationName of the application from which the data file was created.
If this constant is used, <Result> will be a character string with the following format:
<Executable name>(<Project name>).
hComputerName of the computer from which the data file was created.
If this constant is used, <Result> will have the following format:
<Name of client computer> + TAB + <IP address of client computer>.
hCreatorName of file owner.
If this constant is used, <Result> is a character string.
hDateCreation date of the data file.
If this constant is used, <Result> is a string in the following format: YYYYMMDDHHmmSSCCC.
hNotesDescription of the data file or any other information associated with the data file by HModifyFileProperty.
If this constant is used, <Result> is a character string.
hOwnerOwner of data file.
If this constant is used, <Result> is a character string.
<Database>: Character string
Name of the database containing the file whose properties are requested.
If this parameter corresponds to an empty string (""), the database defined in the connection will be used.
A WLanguage error occurs if no database is defined in the connection.
<Data file>: Character string
Name of HFSQL data file whose properties are requested. The file extension must be specified.
Remarks
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