Difference between revisions of "LABEL()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return field description | Function to return field description | ||
| − | |||
==Syntax== | ==Syntax== | ||
LABEL(<expN>) | LABEL(<expN>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[SQL Constraints|CONSTRAINTS | + | [[ADESC()]], [[AFIELDS()]], [[ALTER TABLE]], [[SQL Constraints|CONSTRAINTS]], [[CREATE TABLE]], [[DATABASE()]], [[DBF()]], [[DESCRIPTION Column Constraint]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FLDLIST()]], [[INDEXKEY()]], [[LIST STRUCTURE]], [[NDX()]], [[RTOS()]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
If <expN> exceeds the number of fields in the table, or there is no currently selected table, then LABEL() returns a null string. | If <expN> exceeds the number of fields in the table, or there is no currently selected table, then LABEL() returns a null string. | ||
| − | |||
==Example== | ==Example== | ||
| Line 29: | Line 25: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | [[Category: | + | [[Category:Cursor Functions]] |
| − | + | ||
Latest revision as of 10:52, 4 February 2013
Contents
Purpose
Function to return field description
Syntax
LABEL(<expN>)
See Also
ADESC(), AFIELDS(), ALTER TABLE, CONSTRAINTS, CREATE TABLE, DATABASE(), DBF(), DESCRIPTION Column Constraint, DISPLAY STRUCTURE, FIELD(), FIELDNAME(), FILTER(), FLDCOUNT(), FLDLIST(), INDEXKEY(), LIST 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 ?
