FIELDCALCULATED()

Purpose

Function to return a string containing the specified field's calculated column constraint

Syntax

FIELDCALCULATED(<workarea>|<alias>,<cField>)

See Also

ADESC(), AFIELDS(), ALTER TABLE, ASTORE(), ASTRING(), Calculated Column Constraint, Constraints, CREATE TABLE, DBF(), FIELD(), FIELDCHECKUNIQUE(), FIELDCHOICES(), FIELDINFO(), FIELDNAME(), FIELDRECALCULATE(), FILTER(), FLDCOUNT(), FLDLIST(), GETDATAMAPPING(), INDEXKEY(), KEYLOOKUP(), LABEL(), LIST DICTIONARY, NDX(), RTOS(), SETDATAMAPPING()

Description

The FIELDCALCULATED() function is used to return a string containing the calculated column constraint for the specified field <cField> from the table open in the specified workarea/cursor number or with the specified alias name.

From v9.8.4.

Example

open database southwind
alter table example modify constraint account_no set checkunique
alter table example modify constraint limit recalculate
alter table example modify constraint balance recalculate
alter table example modify constraint available calculated limit - balance
use example
? fieldcheckunique("example","account_no")
.T.
? fieldrecalculate("example","limit")
.T.
? fieldcalculated("example","available")
limit - balance
use
use example in 3
? fieldcheckunique(3,"account_no")
.T.
? fieldrecalculate(3,"balance")
.T.
? fieldcalculated(3,"available")
limit - balance