help on update

why the heck do i get an error here?!

q)k:([k:1 2]w:ab);v:([i:pq]k:k$1 2);update k:2 from v where i=p
'type

Hi Jack,

Its because column i in v is an enumeration of k and therefore it is stored as int (index). You are comparing an int to symbol hence the type error.?

Thanks Rory

Sorry it appears I was mistaken.?

It was because you called your column ā€œiā€. I is the hidden index column on all tables and is always an int.

Thanks Rory?