A .find()
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: