Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Password
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
Allows you to update the structure of a HFSQL data file by performing an automatic data modification (also called Synchronization of the Structure of Deployed Data).
Caution: Links are not managed (no creation or update of existing links).
Versions 18 and later
Java This function is now available for Java applications.
New in version 18
Java This function is now available for Java applications.
Java This function is now available for Java applications.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Update the structure of data file Customer in the background
<Result> = <Source>.ModifyStructure([<Option> [, <New password> [, <Save> [, <Progress Bar>]]]])
<Result>: Boolean
  • True if the automatic data modification was performed,
  • False otherwise. ErrorInfo and HErrorInfo are used to identify the error.
<Source>: Type corresponding to the specified source
Name of data file (defined in the analysis) whose structure must be updated.
<Option>: Optional constant (or combination of constants)
Options for the automatic data modification:
(Default value)
Default operating mode of the automatic data modification.
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.
hmsBackgroundTaskA hot automatic modification is performed (available for the HFSQL Client/Server data files only).

Remark: In hmsNormal or hmsNoCheck mode, the data file used must not be opened (by the application or by another application).
<New password>: Optional character string (with quotes)
  • 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.
<Save>: Optional character string (with quotes)
  • Backup directory.
  • Empty string ("") to perform no backup (default value).
<Progress Bar>: Optional control name or window name
Name of Progress Bar control or name of window used to show the progress of automatic data modification.
Java This parameter is not available.


If <Source>.ModifyStructure 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 <Source>.Password. If the password is incorrect:
Component: wd260hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment