ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
CalculatedDefaultValue (Property)
In french: ValeurParDéfautCalculée
Warning
From version 26, CalculatedDefaultItem is kept for backward compatibility. This property is replaced by CalculatedDefaultValue.
The CalculatedDefaultValue property is used to:
  • Finding out the SQL expression defining the default value of an item. This item was defined in the data model editor or through programming.
  • Define the SQL expression that returns the default value of an item (item described through programming only).
Example
AFile is File Description
AnItem is Item Description
AnItem.Name = "CmdDate"
AnItem.Type = hItemDateTime
AnItem.CalculatedDefaultValue = "SYSDATE"
HDescribeItem(AFile, AnItem)
Syntax

Finding out the SQL expression defining the default value of an item Hide the details

<Result> = <Data file>.<Item>.CalculatedDefaultValue
<Result>: Character string
SQL expression defining the default value of the item.
<Data file>: File name
Name of the data file used.
<Item>: Item name
Name of item used.
Reports and Queries

Defining the SQL expression that returns the default value of an item described through programming Hide the details

<Item>.CalculatedDefaultValue = <SQL expression>
<Item>: Item name
Name of the item used. This name was defined by the Item Description type.
<SQL expression>: Character string
SQL expression defining the default value of the item. This expression must not use any other items.
Remarks
To define a constant default value, use DefaultValue.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help