Difference between revisions of "GETDATAMAPPING()"

From Lianjapedia
Jump to: navigation, search
 
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[ASTORE()]], [[ASTRING()]], [[GETDATAMAPPING Column Constraint|Getdatamapping Column Constraint]], [[SQL Constraints|Constraints]], [[CREATE TABLE]], [[Data Mapping]], [[DBF()]], [[FIELD()]], [[FIELDCHOICES()]], [[FIELDINFO()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[INDEX]], [[INDEXKEY()]], [[KEYLOOKUP()]], [[LABEL()]], [[LIST DICTIONARY]], [[NDX()]], [[RTOS()]], [[SETDATAMAPPING()]]
+
[[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[ASTORE()]], [[ASTRING()]], [[GETDATAMAPPING Column Constraint|Getdatamapping Column Constraint]], [[SQL Constraints|Constraints]], [[CREATE TABLE]], [[Data Mapping]], [[DBF()]], [[FIELD()]], [[FIELDAUTOSUGGESTIONS()]], [[FIELDAUTOSUGGESTIONHEADERS()]], [[FIELDCHOICES()]], [[FIELDINFO()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[INDEX]], [[INDEXKEY()]], [[KEYLOOKUP()]], [[LABEL()]], [[LIST DICTIONARY]], [[NDX()]], [[RTOS()]], [[SETDATAMAPPING()]]
  
 
==Description==
 
==Description==

Latest revision as of 04:55, 27 March 2018

Purpose

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

Syntax

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

See Also

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

Description

The GETDATAMAPPING() function is used to return a string containing the getdatamapping 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
? getdatamapping(1,"productid")
keylookup("products", "productid",{}, productname)
? getdatamapping("order_details","productid")
keylookup("products", "productid",{}, productname)