Description:
Get field names from records according to sequence numbers of these fields.
Syntax:
r. fname(i)
Note:
The function gets the name of the field whose sequence number is i from record r. If no parameter is present, then return all field names in r.
Parameter:
|
r |
Record |
|
i |
Sequence number of a field |
Return value:
Character string/Sequence
Example:
|
|
A |
|
|
1 |
=demo.query("select * from EMPLOYEE") |
|
|
2 |
=A1(1).fname(2) |
“NAME”, the name of the 2nd field in the first record is NAME. |
|
3 |
=A1(1).fname() |
Return a sequence comprising all field names of the 1st record in A1.
|
Related function: