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 inalterability characteristics of a data file (only for data files defined programmatically).
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
AFile is File Description
AnItem is Item Description
 
// Describe the "Customer" data file
AFile.Name = "Customer"
AFile.Type = hFileNormal
AFile.Unalterable = True
 
// Item description
AnItem.Name = "Message"
AnItem.Type = hItemText
AnItem.Size = 40
HDescribeItem(AFile, AnItem)
 
// Validate the data file description
HDescribeFile(AFile)
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: 12/06/2024

Send a report | Local help