HModifyDatabaseProperty (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

HModifyDatabaseProperty

Presentation

Example

Changing the owner of a database

HAddScheduledOptimization

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

Changing the owner of a database

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HModifyDatabaseProperty (Function)

In french: HModifiePropriétéBaseDeDonnées

Available only with this kind of connection

Modifies the properties of a database located on an HFSQL server.

Remark: To find out the properties of a database, use HInfoDatabaseProperty. Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

Example

ResModif is boolean
ResModif = HModifyDatabaseProperty("MyConnection", hOwner, "Flora", "MyDatabase")
IF ResModif = True THEN
Info("Modification performed")
END

Syntax

<Result> = HModifyDatabaseProperty(<Connection> , <Property to modify> , <New value> , <Database>)

<Result>: Boolean

True if the properties have been modified,
False otherwise. HErrorInfo is used to identify the error.

<Connection>: Character string (with or without quotes) or Connection variable

Connection for which the value of a property must be modified. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a Connection variable.

<Property to modify>: Integer constant

Database property to modify:
hNotes Description of the database or any other information associated with the database.
If this constant is used, <New value> is a character string containing the text of the note.
hOwner Owner of the database. The owner is the one who owns the database. The owner of a database can change. The notion of owner impacts the management of rights.
If this constant is used, <New value> is a character string containing the new name of the owner.

<New value>: Character string (with quotes)

New value for the property.

<Database>: Character string (with or without quotes)

Name of the database whose properties must be modified.
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

Changing the owner of a database

The user specified as new owner must be a user found on the server. A WLanguage error occurs if the user does not exist.
To modify the owner, the user who performs the modification must:
- be a "Super user".
- have the rights to change the owner of the database (rights corresponding to the hRightsChangeOwner constant).

To find out if the user has the appropriate right, use HInfoDatabaseProperty.

Component : wd260hf.dll