PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
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
CalculatedDefaultItem (Property)
In french: ValeurParDéfautCalculée
..CalculatedDefaultItem is used to:
  • Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the default value of a item (when the item is described by programming).
Versions 22 and later
WINDEVJava This property is now available for Java applications.
Android This property is now available for the 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 the 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 the 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..CalculatedDefaultItem = "SYSDATE"
HDescribeItem(AFile, AnItem)
Syntax

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

<Result> = <File Name>.<Item Name>..CalculatedDefaultItem
<Result>: Character string (with quotes)
SQL expression defining the default value of the item.
<Name of the file>: Character string (with or without quotes)
Name of data file used.
<Name of the heading>: Character string (with or without quotes)
Name of item used.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadUniversal Windows 10 AppWindows MobileAjaxUser code (UMC)

Defining the SQL expression returning the default value of a item described by programming Hide the details

<Name of the heading>..CalculatedDefaultItem = <SQL expression>
<Name of the heading>: Character string (with or without quotes)
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