FIELDINFO()

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Function to return a string containing comma-separated information about a specified field


Syntax

FIELDINFO(<expN1> [, <expN2>])


See Also

ADESC(), AFIELDS(), ASTORE(), ASTRING(), DBF(), FIELD(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), FMT(), INDEXKEY(), LABEL(), NDX(), RTOS()


Description

The FIELDINFO() function is used to return a string containing comma-separated information about a specified field <expN1> in the currently selected table or the workarea/cursor numbered <expN2>. Fields are numbered from 1 to FLDCOUNT() according to their position in the table structure.

If <expN1> exceeds the number of fields in the table, or there is no currently selected table or no table open in workarea <expN2>, then FIELDINFO() returns a null string.

Otherwise, the information string is structured as follows:


# Value
1 Field name
2 Field type
3 Field width
4 Field decimals
5 Field description
6 Field default value
7 Field picture value
8 Field choices value
9 Field validation expression
10 Field validation error text
11 Field help/tooltip text
12 Field mandatory ("1" if True)
13 Field autoinc ("1" if True)


Example

open database southwind
use example
astore(a_info,fieldinfo(1,1),",")
display memory


Products

Recital Server, Recital