PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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).
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.
<File Name>: Character string (with or without quotes)
Name of data file used.
<Item Name>: Character string (with or without quotes)
Name of item used.
WEBDEV - Server codeAjax

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

<Item Name>..CalculatedDefaultItem = <SQL Expression>
<Item Name>: 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