fname()

Here’s how to use fname() function.

T.fname(i )

Description:

Get the names of fields of the table sequence according to sequence numbers of these fields.

Syntax:

T. fname(i)

Note:

The function gets the name of the field whose sequence number is i from table sequence T. Return all field names in T If no parameter is present.

Parameter:

T	Table sequence
i	Sequence number of a field

Return value:

String/Sequence

Example:

	A
1	=demo.query("select EID,NAME,DEPT,SALARY from EMPLOYEE")
2	=A1.fname(2)	Return “NAME”.
3	=A1.fname()	Return a sequence comprising all field names in A1.

Related function:

r.fname()

r.fname(i )

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:

T.fname()