HomePage esProc Function Reference C C ＜Previous |

C

Read（790） Label: parent table, higher level parent table, column reference,

Description:

A column in a table, its parent table, or a table above them.

Note:

It is a column in a table, its parent table, or a higher level parent table; can be referenced directly by name without being prefixed by the table name. For example, if table A1 is table B1’s parent table, then a column of table A1 can be directly referenced by name from table B1, instead of using a format like A1.C.

 

Note: If one of table B1’s columns is referenced from table A1, the format should be B1.C.

Example:

 

A

 

1

=create(k1,v1).record([1,10,2,20,3,30,4,40,10,100]) .sort(k1)

Generate a table sequence:

2

=create(k1,k2,v2).record([1,1,"a",2,1,"c"])

Generate a table sequence:

3

=file("D:/ctb.ctx")

 

4

=A3.create(#k1,v1)

Create the composite table’s primary table

5

=A4.attach(table2,#k2,v2)

Add subtable table2 to the primary table.

6

=A4.append(A1.cursor())

 

7

=A5.append(A2.cursor())

 

8

=A4.cursor(k1,v1,table2.v2).fetch()

Reference column v2 of the subtable table2 from its parent table.

9

=A5.cursor(k1,v1,v2).fetch()

Reference columns k1 and v1 of the parent table from the subtable.