Hi all,I have some questions on breaking the escape character.for example, I have a trade tabletime sym price size---------------------------09:30:00.000 a 10.75 100How can I make a query with my defined colum header with () or ,like:select MySym[A]:sym, price from tradeMySym[A] price---------------------------a 10.75Adrian
X-Mailer: Apple Mail (2.935.3)
These are used extensively, so I cant imagine the amount of
interesting side effects from doing this - try doing a select from it,
just for starters
q)tbl:(a:1 2 3;b:5 6 7)
q)(`$(“a[s]d”;“j(k)l”))xcol tbl
a[s]d j(k)l
1 5
2 6
3 7
FWIW, you’ll have similar problems if you try touse a built-in name (e.g., var) as a column name.It’s doable but it’s a bit of a pain.-- O.L.
nothing compared to the pain you’ll have if you create yourself a table with columns called delete, from and where
.Q.res is a list of reserved words, key`.q will give you q names to avoid