FIELDCHOICES()
From Lianjapedia
Contents
Purpose
Function to return a string containing the specified field's choices column constraint
Syntax
FIELDCHOICES(<workarea>|<alias>,<cField>)
See Also
ADESC(), AFIELDS(), ALTER TABLE, ASTORE(), ASTRING(), Choices Column Constraint, Constraints, CREATE TABLE, DBF(), FIELD(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), GETDATAMAPPING(), INDEXKEY(), KEYLOOKUP(), LABEL(), LIST DICTIONARY, NDX(), RTOS(), SETDATAMAPPING()
Description
The FIELDCHOICES() function is used to return a string containing the choices 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 ? fieldchoices(1,"productid") select productname from products order by productname ? fieldchoices("order_details","productid") select productname from products order by productname