ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Unalterable (Property)
In french: Inaltérable
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
The property Unalterable property is used to set the inalterability of a data file: the data file cannot be modified; only additions are possible.
You can:
  • Find out whether a data file is unalterable or not (data file defined in the data model editor or through programming).
  • Define the characteristics regarding the unalterability of a data file (when describing the data file through programming only).
Reminder: The inalterability of files:
  • avoids programming errors by preventing modification or deletion (via HModify/HDelete, or via a query).
  • adds a hash of the record content to each record. This hash is an HMAC-SHA256 hash, whose key is derived from the file encryption password.
Example
UnFichier is File Description
UneRubrique is Item Description

// Description du fichier de données "Client"
UnFichier.Name = "Client"
UnFichier.Type = hFileNormal
UnFichier.Unalterable = True

// Description de la rubrique 
UneRubrique.Name = "Message"
UneRubrique.Type = hItemText
UneRubrique.Size = 40
HDescribeItem(UnFichier, UneRubrique)

// Valide la description du fichier de données 
HDescribeFile(UnFichier)
Syntax

Finding out whether a data file is unalterable or not Hide the details

<Result> = <Data file>.Unalterable
<Result>: Boolean
  • True if the data file is unalterable,
  • False otherwise.
<Data file>: Character string
Name of the data file used. This name was defined in the data model editor or with the File Description type.

Defining the characteristics regarding the unalterability of a data file (data file defined through programming) Hide the details

<Data file>.Unalterable = <Unalterability>
<Data file>: Character string
Name of the data file used. This name is defined with the File Description type.
<Unalterability>: Boolean
  • True if the data file must be unalterable,
  • False otherwise.
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/13/2025

Send a report | Local help