Description:
Return an attached table’s records as a sub table sequence.
Syntax:
T{x:C,…}
Description:
The function returns an attached table’s records that match the current primary key value as a sub table sequence.
Parameter:
T |
An attached table. |
x |
An attached table’s column. |
C |
Column alias; can be omitted. |
Example:
|
A |
|
1 |
=create(k1,v1).record([1,10,2,20,3,30,4,40,10,100]) |
Create a table sequence:
|
2 |
=create(k1,k2,v2).record([1,1,"a",2,4,"c",2,8,"b"]) |
Create a table sequence:
|
3 |
=file("D:/ckv.ctx") |
|
4 |
=A3.create(#k1,v1) |
Create the composite table’s base table. |
5 |
=A4.attach(table2,#k2,v2) |
Add an attached table to the base table. |
6 |
=A4.append(A1.cursor()) |
Append data to the base table. |
7 |
=A5.append(A2.cursor()) |
Append data to the attached table. |
8 |
=A4.cursor(k1,table2{k2,v2}:t2).fetch() |
Return records of attached table table2 as a table sequence.
|