PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WinDevWebDev - Server codeWebDev - Browser codeWinDev MobileReports and QueriesWindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPadJavaPHPAjaxUser code (UMC)External languageHFSQLHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBODBCNative Accesses

HChangePassword (Function)
In French: HChangeMotDePasse

Changes the password of a 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.

Notes:

  • If the data file is already password protected, this must be specified with HPass before using HChangePassword.
  • To modify the password of a data file, you must have the rights for 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.

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 the HFSQL data file (defined in the analysis).
<New Password>: Character string (with quotes)
New password that will be used for the data file.

Components
Reports and Queries wd190hf.dll
See also
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment