PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
  • 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
<Connection variable>.ModifyDatabaseProperty (Function)
In french: <Variable Connexion>.ModifieProprié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 <Connection variable>.InfoDatabaseProperty.
Example
// Describe the connection
MyConnection is Connection
 
ResModif is boolean
ResModif = MyConnection.ModifyDatabaseProperty(hOwner, "Flora", "MyDatabase")
IF ResModif = True THEN
Info("Modification performed")
END
Syntax
<Result> = <Connection>.ModifyDatabaseProperty(<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>: Connection variable
Name of the Connection variable that describes the connection for which the value of a property must be modified.
<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 <Connection variable>.InfoDatabaseProperty.
Component: wd270hf.dll
See also
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment