fname()

Read(2108) Label: fname,

Here’s how to use fname() function.

T.fname(i )

Description:

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

Syntax:

T. fname(i)

Note:

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

Parameter:

T

Table sequence

i

Ordinal 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 the ordinal numbers of these fields.

Syntax:

r. fname(i)

Note:

The function gets the name of the field whose ordinal number is i from record r. If no parameter is present, then return all field names in r.

Parameter:

r

Record

i

Ordinal 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()