Difference between revisions of "FIELD()"

Revision as of 04:55, 7 December 2012

Purpose

Function to return field name

Syntax

FIELD(<expN1>[,<workarea | alias>[,<expN3>]])

See Also

ADESC(), AFIELDS(), DBF(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), INDEXKEY(), LABEL(), NDX(), RTOS()

Description

The FIELD() function is synonymous with the FIELDNAME() function. It returns the name of the field <expN1> in the currently selected table. The optional <workarea | alias> parameter can be used to operate on the table in the specified workarea number, or with the specified table alias. If the optional <expN3> is specified and evaluates to 1, the field data type initial (e.g. 'C' for character), the field width and the field value will also be returned along with the fieldname in a comma separated string.

If <expN1> exceeds the number of fields in the table, or there is no currently selected table, then FIELD() returns a null string. Field offsets start at 1. The FIELD() function always returns a character string in upper case.

Example

use payroll
declare fname[fcount()]
for n=1 to fcount()
    fname[n] = field(n)
    ?fname[n]
next
?
 
use demo
go top
? field(1,1,1)
ACCOUNT_NO,C,5,00046