FIELDAUTOSUGGESTIONHEADERS()

Purpose

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

Syntax

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

See Also

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

Description

The FIELDAUTOSUGGESTIONHEADERS() function is used to return a string containing the autosuggestionheaders 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