failed to update table with column as list

Community Support
1

I have a non-keyed table and one of the column is a list:
test:(datetime:();list:())
test insert(2011.06.14D02:12:34.1481814;((2498f;8000;0);(2500f; 0;5000))) test[0]:(2011.06.14D02:12:34.1481814;((2498f;8000;0);(2500f;0;999)))
–>'assign
test:update datetime:2019.06.15D01:48:18.6556482 from test where i =0
–>ok
test:update list:((2498f;8000;0);(2500f;0;999)) from test where i =0
–>'length

I cannot update the column…pls help

2

test:update list:enlist((2498f;8000;0);(2500f;0;999)) from test wherei =0Mohammad NoorOn Jun 13, 8:06?pm, Alex <alexc…> wrote:> I have a non-keyed table and one of the column is a list:> test:(datetime:();list:())> test insert(2011.06.14D02:12:34.1481814;((2498f;8000;0);(2500f;&gt; 0;5000)))&gt; test[0]:(2011.06.14D02:12:34.1481814;((2498f;8000;0);(2500f;0;999)))> –>'assign> test:update datetime:2019.06.15D01:48:18.6556482 from test where i =0> –>ok> test:update list:((2498f;8000;0);(2500f;0;999)) from test where i =0> –>'length>> I cannot update the column…pls help</alexc…>

3

I think your problem is with the left hand side of the assignment. You wrote:

`test[0]: … something…

You probably meant:

test[0]: … something…

The insert function will accept either the symbolic name of the table (e.g., `test) or a reference to it. Assignment, however, always wants a reference. If you change the lhs of your assignment, it works fine:

q)test[0]:(2011.06.14D02:12:34.1481814;((2498f;8000;0);(2500f;0;999)))
q)test
datetime                      list                        

2011.06.14D02:12:34.148181400 2498f 8000 0   2500f 0    999