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
Used to find out the properties of a database on an HFSQL server.
Example
// Describe the connection
HDescribeConnection("MyConnection", "Julia", "Password", ...
"MyHFServer", "MyDatabase", hAccessHFClientServer, hORead)
// Open the connection
HOpenConnection("MyConnection")
...
OwnerName is string
OwnerName = HInfoDatabaseProperty("MyConnection", ...
hOwner, "MyDatabase")
IF OwnerName <> "" THEN
Trace("Owner of the database: " + OwnerName)
END
Syntax
<Result> = HInfoDatabaseProperty(<Connection> , <Property> , <Database>)
<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
Property to get from the database:
hApplicationName of the application from which the database was created.
If this constant is used, <Result> is a character string with the following format: <Executable name>(<Project name>).
hComputerName of the computer from which the element was created.
If this constant is used, <Result> has the following format: <Name of client computer> + TAB + <IP Address of client computer>.
hCreatorName of the database creator. This information has no influence.
If this constant is used, <Result> is a character string.
hDateCreation date of the database.
If this constant is used, <Result> is a string in the following format: YYYYMMDDHHmmSSCCC.
hNotesDatabase description or any other information associated with the database by HModifyDatabaseProperty.
If this constant is used, <Result> is a character string.
hOwnerOwner of the database.
The owner is the one who owns the database. The owner of a database can be modified by HModifyDatabaseProperty.
If this constant is used, <Result> is a character string.
<Database>: Character string
Name of the database 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.
Remarks
To modify the properties of a database, use HModifyDatabaseProperty.
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