'assign error

[Bob]

When I try to create a table I get an assign error.


q)UK_US_ORDERS:([] date:(); time:(); sym:(); size:(); price:(); type:())
'assign


[admin]

The assign error occurs when you try to assign a value to a kdb keyword. “type” is a reserved word. Notice your code works when I change that one word.


q)UK_US_ORDERS:([] date:(); time:(); sym:(); size:(); price:(); TYPE:())
q)UK_US_ORDERS
date time sym size price TYPE
-----------------------------
q)


It is possible to workaround this limitation to make your column named type but it would only leave your table extremely hard to query so it is not recommended.

[Author]

Posts