FIELDAUTOSUGGESTIONS()
Contents
Purpose
Function to return a string containing the specified field's autosuggestions column constraint
Syntax
FIELDAUTOSUGGESTIONS(<workarea>|<alias>,<cField>)
See Also
ADESC(), AFIELDS(), ALTER TABLE, ASTORE(), ASTRING(), Autosuggestions, Autosuggestions Column Constraint, Constraints, CREATE TABLE, Data Mapping, DBF(), FIELD(), FIELDAUTOSUGGESTIONHEADERS(), FIELDCHOICES(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), GETDATAMAPPING(), INDEX, INDEXKEY(), KEYLOOKUP(), LABEL(), LIST DICTIONARY, NDX(), RTOS(), SETDATAMAPPING()
Description
The FIELDAUTOSUGGESTIONS() function is used to return a string containing the autosuggestions 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 customers ? fieldautosuggestions("customers","contacttitle") select distinct contacttitle,contactname from customers ? fieldautosuggestionheaders("customers","contacttitle") Title,Name ? fieldautosuggestions(1,"contacttitle") select distinct contacttitle,contactname from customers ? fieldautosuggestionheaders(1,"contacttitle") Title,Name