fname()

Read(186) 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 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.

Parameters:

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 functions:

r.fname()

r .fname( i )

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.

Parameters:

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 functions:

T.fname()