Difference between revisions of "FIELD()"
Helengeorge (Talk | contribs) (→Products) |
Yvonnemilne (Talk | contribs) |
||
| (5 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return field name | Function to return field name | ||
| Line 9: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[AFIELDS()]], [[DBF()]], [[FIELDNAME()]], [[FILTER()]], [[FLDLIST()]], [[FMT()]], [[INDEXKEY()]], [[NDX()]], [[RTOS()]] | + | [[ADESC()]], [[AFIELDS()]], [[DBF()]], [[FIELDINFO()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[FMT()]], [[INDEXKEY()]], [[LABEL()]], [[NDX()]], [[RTOS()]] |
Latest revision as of 15:28, 25 August 2011
Purpose
Function to return field name
Syntax
FIELD(<expN1>[,<workarea | alias>[,<expN3>]])
See Also
ADESC(), AFIELDS(), DBF(), FIELDINFO(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), FMT(), 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
Products
Recital Server, Recital
