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/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).
Versions 22 and later
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android widget mode.
New in version 22
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android widget mode.
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android widget mode.
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.
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadUser code (UMC)Ajax

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