PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Changing the owner of a database
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 found on a 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
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the 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:
<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 (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 proper rights are granted to the user, use HInfoDatabaseProperty.
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment