Difference between revisions of "SETDATAMAPPING()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Function to return a string containing the specified field's setdatamapping column constraint ==Syntax== SETDATAMAPPING(<workarea>|<alias>,<cField>) ==See Also==...") |
Yvonne.milne (Talk | contribs) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[ASTORE()]], [[ASTRING()]], [[CHOICES Column Constraint|Choices Column Constraint]], [[SQL Constraints|Constraints]], [[CREATE TABLE]], [[Data Mapping]], [[DBF()]], [[FIELD()]], [[FIELDCHOICES()]], [[FIELDINFO()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[GETDATAMAPPING()]], [[INDEXKEY()]], [[LABEL()]], [[LIST DICTIONARY]], [[NDX()]], [[RTOS()]] | + | [[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[ASTORE()]], [[ASTRING()]], [[CHOICES Column Constraint|Choices Column Constraint]], [[SQL Constraints|Constraints]], [[CREATE TABLE]], [[Data Mapping]], [[DBF()]], [[FIELD()]], [[FIELDCHOICES()]], [[FIELDINFO()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[GETDATAMAPPING()]], [[INDEXKEY()]], [[KEYLOOKUP()]], [[LABEL()]], [[LIST DICTIONARY]], [[NDX()]], [[RTOS()]] |
==Description== | ==Description== |
Revision as of 10:49, 23 March 2018
Contents
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(), Choices Column Constraint, Constraints, CREATE TABLE, Data Mapping, DBF(), FIELD(), FIELDCHOICES(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), GETDATAMAPPING(), 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 )