PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
HChangePassword (Function)
In french: HChangeMotDePasse
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Changes the password of a 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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Former password
HPass("*", "Password")
// Modify the password
HChangePassword(Customer, "NewPassword")
// Create a 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(<File name> , <New Password>)
<Result>: Boolean
  • True if the password was modified,
  • False otherwise. HError is used to identify the error.
<File name>: Character string (with or without quotes)
Logical name of HFSQL data file (defined in the analysis).
<New Password>: Character string (with quotes)
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 : wd240hf.dll
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment