ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Changing the owner of a database
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
HModifyDatabaseProperty (Function)
In french: HModifiePropriétéBaseDeDonnées
HFSQL Client/ServerAvailable 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.
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 or Connection variable
Connection for which the value of a property must be modified. This connection corresponds to:
<Property to modify>: Integer constant
Database property to modify:
hNotesDescription 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.
hOwnerOwner 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
New value for the property.
<Database>: Character string
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 determine if the user has the appropriate rights, use HInfoDatabaseProperty.
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