PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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:
  • Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression that returns the default value of an item (item described by 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 (with quotes)
SQL expression defining the default value of the item.
<Data file>: File name
Name of data file used.
<Item>: Item name
Name of item used.
WEBDEV - Server codeAjax

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

<Item>.CalculatedDefaultValue = <SQL expression>
<Item>: Item name
Name of item used. This name was defined by the Item description type.
<SQL expression>: Character string (with quotes)
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