Description:
Union the members of a cursor sequence, and return result as a multicursor.
Syntax:
CS.conj()
Note:
The function concatenates members of CS, a sequence of cursors, and returns result as a multicursor. This is actually the merging of data in the cursors. Each cursor in CS must have the same structure.
This is a delayed function.
Parameter:
CS |
A sequence of cursors. |
Return value:
Multicursor
Example:
|
A |
|
1 |
=connect("demo").cursor("SELECT top 3 * FROM scores where SUBJECT='English' ") |
Return a cursor, whose data is as follows:
|
2 |
=connect("demo").cursor("SELECT top 3 * FROM scores where SUBJECT='Math' ") |
Return a cursor, whose data is as follows:
|
3 |
=connect("demo").cursor("SELECT top 3 * FROM scores where SUBJECT='PE' ") |
Return a cursor, whose data is as follows:
|
4 |
=[A1,A2,A3] |
Return a sequence consisting of the three cursors. |
5 |
=A4.conj() |
Concatenate records of members cursors in A4’s sequence and return a cursor. |
6 |
=A5.fetch() |
Fetch data from cursor A5: |
Related function: