Here’s how to use fname() function.
Description:
Get the names of fields of the table sequence according to the serial numbers of these fields.
Syntax:
T. fname(i)
Note:
The function gets the name of the field whose serial number is i from table sequence T. Return all field names in T If no parameter is present.
Parameter:
T |
Table sequence |
i |
Serial number of a field. |
Return value:
A string or a sequence
Example:
|
A |
|
1 |
=demo. query("select * from EMPLOYEE") |
|
2 |
=A1.fname(2) |
“NAME”, the name of the 2nd field is NAME. |
3 |
=A1.fname() |
Return a sequence comprising all field names in A1.
|
Related function:
Description:
Get the field names from records according to the serial numbers of these fields.
Syntax:
r. fname(i)
Note:
The function gets the name of the field whose serial number is i from record r. If no parameter is present, then return all field names in r.
Parameter:
r |
Record |
i |
Serial number of a field |
Return value:
Character strings or sequences
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: