cs .id()

Read(159) Label: cursor, sequence of sequences,

Description:

Generate a sequence consisting of values of fields in a given cursor.

Syntax:

cs.id(xi,…;n)

Note:

The function generates a sequence of sequences, each of which is made up of values of xi field in cursor cs. Get at most n values for each xi field; return a sequence when there is only one xi field.

Parameters:

cs

Cursor

xi

Expression; use comma to separate multiple expressions

n

Integer; return all values when omitted

Return value:

Sequence

Example:

 

A

 

1

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

 

2

=A1.id(#1,DEPT;5)

3

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

 

4

=A3.id(DEPT;5)