FLDLIST( )

Topic group Related topics

Returns the fields and calculated field expressions of a SET FIELDS TO list.

Syntax

FLDLIST([<field number expN>])

<field number expN>

The position of the field or calculated field expression in a SET FIELDS TO list whose name you want returned. If you do not specify a field number, FLDLIST( ) returns the entire field list.

Description

FLDLIST( ) returns the field or calculated field expression in a SET FIELDS TO list that corresponds to a specified field number. If you do not specify a field number, FLDLIST( ) returns the entire field list. Each field name or expression in the field list is separated by a comma. FLDLIST( ) always returns fully-qualified field names, that is, it includes the table or alias name. For read-only fields, FLDLIST( ) appends "/R" to the field name.

FLDLIST( ) returns the field list even if SET FIELDS is OFF. If there is no SET FIELDS TO list, or the specified field number exceeds the number of items in the field list, FLDLIST( ) returns an empty string ("").

OODML

Check the fieldName property of the Field object for a normal field. A calculated field is defined by either its value property, or by its beforeGetValue event.