Re: SQL query to Functional query[Parse Tree]

[Laura]

Hi David,

Thanks for your kindly reply. I want to use functional query, because I have in each table a field(time-date) to be converted into timestamp. So, instead of using something like this:

update "p"$datefield from dictionary[`table1] 
update "p"$datefield2 from dictionary[`table2] 
update "p"$datefield3 from dictionary[`table3]

I wanted to use this:

coldic:`table1`table2`table2!`datafield`datafield2`datafield3 {![`dictionary[x];();ob;(enlist `coldic[x])!enlist($;"p";`coldic[x])] x} each key coldic

But it is not updating the tables, this is the output :

“” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” ..

I’m sorry for not being clear in my concern,

Thanks,

Richard