SETDATAMAPPING()

From Lianjapedia
Revision as of 04:59, 27 March 2018 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

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

Syntax

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

See Also

ADESC(), AFIELDS(), ALTER TABLE, ASTORE(), ASTRING(), Autosuggestions, Setdatamapping Column Constraint, Constraints, CREATE TABLE, Data Mapping, DBF(), FIELD(), FIELDAUTOSUGGESTIONS(), FIELDAUTOSUGGESTIONHEADERS(), FIELDCHOICES(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), GETDATAMAPPING(), INDEX, INDEXKEY(), KEYLOOKUP(), LABEL(), LIST DICTIONARY, NDX(), RTOS()

Description

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

Example

open database southwind
use order_details
? setdatamapping(1,"productid")
keylookup("products", "productname", "{}", productid )
? setdatamapping("order_details","productid")
keylookup("products", "productname", "{}", productid )