PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

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
MyConnection is Connection
 
// Open the connection
MyConnection.OpenConnection()
...
OwnerName is string
OwnerName = MyConnection.InfoDatabaseProperty(...
hOwner, "MyDatabase")
IF OwnerName <> "" THEN
Trace("Owner of the database: " + OwnerName)
END
Syntax
<Result> = <Connection>.InfoDatabaseProperty(<Property> , <Database>)
<Result>: Character string
  • Value of requested property,
  • Empty string ("") if an error occurred.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which a property value is requested.
<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 <Connection variable>.ModifyDatabaseProperty.
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 <Connection variable>.ModifyDatabaseProperty.
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 <Connection variable>.ModifyDatabaseProperty.
Component: wd280hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment