ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
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
HChangePassword (Function)
In french: HChangeMotDePasse
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Changes the password of an HFSQL Classic or HFSQL Client/Server data file. The applications that use the former password will no longer be able to access this data file: a password error will be displayed.
Caution: This function is an advanced function. It must be used with great care because it can trigger errors in the client applications.
Example
// Former password
HPass("*", "Password")
// Modify the password
HChangePassword(Customer, "NewPassword")
// Create a data file with password
HPass(FileA, "TEST")
HCreation(FileA)
 
// Add data
FileA.ItemA = "Test 1"
HAdd(FileA)
 
// Read data
HReadFirst(FileA)
Info(FileA.ItemA)
 
// Change the password
Info("Changing the password...")
HChangePassword(FileA, "NW_Test")
Info("Password changed, the first record is read again")
 
// Read data again
HReadFirst(FileA)
Info(FileA.ItemA)
 
// Manage the errors
CASE ERROR:
Error(HErrorInfo())
RETURN
Syntax
<Result> = HChangePassword(<Data file> , <New password>)
<Result>: Boolean
  • True if the password was modified,
  • False otherwise. HError is used to identify the error.
<Data file>: Character string
Name of HFSQL data file (defined in the analysis) to use.
<New password>: Character string
New password that will be used for the data file.
Remarks
  • If the data file is already password protected, this password must be specified with HPass before using HChangePassword.
  • To modify the password of a data file, you must have the rights to perform an automatic modification (hRightsAutoModif constant). These rights can be defined by HModifyFileRights.
  • This function starts an automatic modification of the data file. If the data file was encrypted with a different password, it will be entirely re-encrypted with the new password. This operation can take quite a long time.
Component: wd290hf.dll
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help