Difference between revisions of "FIELD()"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
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()]]
+
[[AFIELDS()]], [[DBF()]], [[FIELDNAME()]], [[FILTER()]], [[FLDLIST()]], [[FMT()]], [[INDEXKEY()]], [[LABEL()]], [[NDX()]], [[RTOS()]]
  
  

Revision as of 14:24, 25 August 2011

Purpose

Function to return field name


Syntax

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


See Also

AFIELDS(), DBF(), FIELDNAME(), FILTER(), 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