HInfoDatabaseProperty (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HInfoDatabaseProperty (Function)

In french: HInfoPropriétéBaseDeDonnées

Available only with this kind of connection

Used to find out the properties of a database on an HFSQL server.

Example

// Description de la connexion
HDescribeConnection("MaConnexion", "Julie", "MotDePasse", "MonServeurHF", "MaBaseDeDonnées", hAccessHFClientServer, hORead)
// Ouverture de la connexion
HOpenConnection("MaConnexion")
...
NomPropriétaire is string
NomPropriétaire = HInfoDatabaseProperty("MaConnexion", hOwner, "MaBaseDeDonnées")
IF NomPropriétaire <> "" THEN 
	Trace("Propriétaire de la base de donnée : " + NomPropriétaire)
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:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Property>: Integer constant

Property of the database:
hApplication Name 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>).
hComputer Name 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>.
hCreator Name of the database creator. This information has no influence.
If this constant is used, <Result> is a character string.
hDate Creation date of the database.
If this constant is used, <Result> is a string in the following format: YYYYMMDDHHmmSSCCC.
hNotes Database description or any other information associated with the database by HModifyDatabaseProperty.
If this constant is used, <Result> is a character string.
hOwner Owner 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 for which to get the properties.
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: wd300hf.dll