ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Password
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Allows you to update the structure of an HFSQL data file by performing an automatic data modification (also called Synchronization of the Structure of Deployed Data).
Attention: Links are not managed (no creation or update of existing links).
To update links, use HUpdateLink.
// Update the structure of data file Customer in the background
HModifyStructure(Customer, hmsBackgroundTask)
Syntax
<Result> = HModifyStructure(<Data file> [, <Option> [, <New password> [, <Backup> [, <Progress Bar>]]]])
<Result>: Boolean
  • True if the automatic data modification was performed,
  • False otherwise. ErrorInfo and HErrorInfo are used to identify the error.
<Data file>: Character string
Name of data file (defined in the analysis) whose structure must be updated.
If this parameter is equal to "*", the automatic data modification will be applied to all the known data files (described in the analysis).
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the analysis (not available in Android and Android widget).
<Option>: Optional constant (or combination of constants)
Options for the automatic data modification:
hmsBackgroundTaskA hot automatic modification is performed (available for the HFSQL Client/Server data files only).
hmsNoCheckThe automatic data modification is performed even if:
  • the description of the file is more recent than the description of the analysis,
  • the GUID of the file differs from the GUID of the analysis.
hmsNormal
(Default value)
Default operating mode of the automatic data modification.
New in version 2025
hmsSavegardeJournal
The following steps are performed during automatic data modification:
  • Backup log files (in log file backup directory).
  • Deleting log files.
  • Start automatic data modification.

Note: In hmsNormal or hmsWithoutControlmode, the data file being handled must not be opened (by the application or by another application)..
<New password>: Optional character string or secret string
  • New password of the data file.
  • Empty string ("") to delete the password.
If this parameter is not specified (or if this parameter corresponds to NULL), the existing password is not modified.
New in version 2025
Secret strings: If you use the secret string vault, the type of secret string used for this parameter must be "Ansi or Unicode string".
To learn more about secret strings and how to use the vault, see Secret string vault.
<Backup>: Optional character string
  • Backup directory.
  • Empty string ("") to perform no backup (default value).
<Progress Bar>: Optional control name or window name
Name of the Progress Bar control or name of the window that shows the progress of the automatic data modification.
Java This parameter is not available.
Remarks

Password

If HModifyStructure is the first function that handles the specified data file, the password is checked when using the data file. This password must have been specified by HPass. If the password is incorrect:
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 17
This page is also available for…
Comments
EXAMPLE
//Globais
iniresult is string = INIRead("APP","VERSAO","",fDataDir() + ["\"] +"CONFIG.INI")

IF (Num = 1 AND iniresult = "") OR (Num = 1 AND iniresult = 0) THEN

Info("UMA VEZ")

INIWrite("APP","VERSAO","2",fDataDir() + ["\"] +"CONFIG.INI")

Info(INIRead("APP","VERSAO","","CONFIG.INI"))

fDelete(fDataDir() + ["\"] +"t000_config.fic")
fDelete(fDataDir() + ["\"] +"t000_config.ndx")
fDelete(fDataDir() + ["\"] +"t000_config.mmo")

END

HModifyStructure("*",hmsBackgroundTask)

HCreationIfNotFound("*","APP634") //SENHA DOS ARQUIVOS
BOLLER
06 Oct. 2017

Last update: 12/13/2024

Send a report | Local help