Difference between revisions of "FIELD()"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
 
(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