A .find()

Read(125) Label: primary key, binary search,

Description:

Find a record according to its primary key value.

Syntax:

A.find(k) 

Note:

 The function finds records from a record sequence/table sequence whose primary key values are k. Use the index table if there is one.

Parameters:

A

A record sequence/table sequence

k

Primary key, which will be written as a sequence if it is a multi-field primary key.

Options:

@b

Enable the binary search. Here, A must be ordered by the primary key; otherwise, the result will be wrong. The index table will be ignored.

@k

Return members of A matching the sequence of key values specified by parameter k

Return value:

Records

Example:

 

A

 

1

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

2

=A1.keys(NAME,DEPT)

 

3

=A1.find(["Alexis","Sales"])

A sequence is used since the key contains two fields

4

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

This table sequence is ordered by the EID field

5

=A4.keys(EID)

 

6

=A4.find@b(3)

 

@b is used to enable the binary search in order to speed up the computation

7

=A4.find@k(2,15,69,220)

With @k option, the function returns members matching the specified key values

Related functions:

A.pfind()