FIELDRECALCULATE()

Purpose

Function to check if the specified field has the recalculate column constraint

Syntax

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

See Also

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

Description

The FIELDRECALCULATE() function is used to check whether the recalculate column constraint is set 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