Access Foreign Key in a constraint in Functional Form of Select

Community Support
1

Hi Q-Gods,

I am just wondering how I can access the foreign key in the constraint of a functional form of select

For example:

a: ([cola: int$()] colb: int$());

b: ( cola: a$(); colc: int$());

`a insert (1, 1);

`a insert (2, 3);

`a insert (3, 5);

`b insert (1, 1);

`b insert (2, 2);

`b insert (3, 3);

What is the corresponding functional form of select for 

select cola, cola.colb, colc from b where colc > cola.colb

Thanks a lot in advance

Charles

2

X-Gm-Message-State: ALoCoQl1jWNXTu6el/CNL5hCu6uUbDqJuh5j8U42zwUGk5oMDf1dbCA4F3iva5zuGo2V1hJ0N9s6Can use parse to figure it outq)0N!parse"select cola, cola.colb, colc from b where colc > cola.colb";(?;b;,,(\>;colc;cola.colb);0b;colacolbcolc!colacola.colbcolc)q)?[b;enlist(>;colc;cola.colb);0b;colacolbcolc!colacola.colbcolc]cola colb colc--------------On Thu, Oct 4, 2012 at 12:35 PM, Charles Lin wrote:> Hi Q-Gods,>> I am just wondering how I can access the foreign key in the constraint of a> functional form of select> For example:>> a: ([cola: int$()] colb: int$());> b: ( cola: a$(); colc: int$());> a insert (1, 1);> a insert (2, 3);> a insert (3, 5);> b insert (1, 1);> b insert (2, 2);> b insert (3, 3);>> What is the corresponding functional form of select for> select cola, cola.colb, colc from b where colc > cola.colb>> Thanks a lot in advance>> Charles

3

Hi Charles,

Cool, I have never thought of using parse to obtain the functional form.
Thanks a lot for your advice :)

Charles