FIELD( ) Function

  • Article

Returns the name of a field, referenced by number, in a table.

FIELD(nFieldNumber [, nWorkArea | cTableAlias])

Return Values

Character

Parameters

  • nFieldNumber
    Specifies the field number. If nFieldNumber is 1, the name of the first field in the table is returned; if nFieldNumber is 2, the name of the second field is returned, and so on. The empty string is returned if nFieldNumber is greater than the number of fields. Field names are returned in upper case.

  • nWorkArea
    Specifies the work area of the table for which FIELD( ) returns field names.

    FIELD( ) returns the empty string if a table isn't open in the work area you specify.

  • cTableAlias
    Specifies the alias of the table for which FIELD( ) returns field names.

    Visual FoxPro generates an error message if you specify a table alias that doesn't exist.

Remarks

If you omit the optional arguments, FIELD( ) returns the names of the fields in the table open in the currently selected work area.

Example

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE customer  && Opens Customer table

CLEAR
FOR gnCount = 1 TO FCOUNT( )  && Loop for number of fields
   ? FIELD(gnCount)  && Display each field
NEXT
?
? 'Number of fields: ' + ALLTRIM(STR(gnCount -1))

See Also

DISPLAY STRUCTURE | FCOUNT( ) | FSIZE( )