Difference between revisions of "LABEL()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[AFIELDS()]], [[ALTER TABLE]], [[SQL Constraints|CONSTRAINTS]], [[CREATE]], [[CREATE TABLE]], [[DATABASE()]], [[DBF()]], [[DESCRIPTION Column Constraint]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[FMT()]], [[INDEXKEY()]], [[LIST STRUCTURE]], [[MODIFY STRUCTURE]], [[NDX()]], [[RTOS()]]
+
[[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[SQL Constraints|CONSTRAINTS]], [[CREATE]], [[CREATE TABLE]], [[DATABASE()]], [[DBF()]], [[DESCRIPTION Column Constraint]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[FMT()]], [[INDEXKEY()]], [[LIST STRUCTURE]], [[MODIFY STRUCTURE]], [[NDX()]], [[RTOS()]]
  
  

Latest revision as of 15:11, 25 August 2011

Purpose

Function to return field description


Syntax

LABEL(<expN>)


See Also

ADESC(), AFIELDS(), ALTER TABLE, CONSTRAINTS, CREATE, CREATE TABLE, DATABASE(), DBF(), DESCRIPTION Column Constraint, DISPLAY STRUCTURE, FIELD(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), FMT(), INDEXKEY(), LIST STRUCTURE, MODIFY STRUCTURE, NDX(), RTOS()


Description

The LABEL() function is used to return the description of the field <expN> in the currently selected table. Fields are numbered from 1 to FLDCOUNT() according to their position in the table structure.

If <expN> exceeds the number of fields in the table, or there is no currently selected table, then LABEL() returns a null string.


Example

close databases
clear
open database southwind
use example
for i = 1 to fldcount()
    ? "Field: " + field(i) + " - Description: " + label(i)
next
?


Products

Recital Server, Recital