CalculatedDefaultValue (Property)

Help

WLanguage

WLanguage properties

HFSQL properties

CalculatedDefaultValue

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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).

Versions 22 and later

This property is now available for Java applications.

New in version 22

This property is now available for Java applications.

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.

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.