k. row()

Read(857) Label: find, key, record,

Description:

Find the record where the key value(s) is/are the specified one(s).

Syntax:

k.row(T)

Note:

The function finds the record whose key value is k in a record sequence/a table sequence/a sequence.

Parameter:

k

A key value; multiple key values will be represented by a sequence

T

A record sequence/a table sequence/a sequence

Return value:

A record

Example:

 

A

 

1

=demo.query("select * from sales")

2

=A1.keys(ORDERID)

Set the key.

3

=2.row(A1)

Find the record whose key value is 2.

4

=A1.select()

Generate a record sequence from A1’s table sequence.

5

=A1.keys(ORDERID,SELLERID)

Set multiple keys.

6

=[1,17].row(A1)

Find the record where key values are [1,17] .

Related function:

A.find()