powerpeanuts
New Contributor
since 3 weeks ago
Monday

User Statistics

  • 3 Posts
  • 0 Solutions
  • 1 Kudos given
  • 2 Kudos received

User Activity

Example: trade:([]time:`time$();sym:`symbol$();price:`float$();size:`int$()); `trade insert(09:30:00.000;`a;10.75;100);`trade insert(09:31:00.000;`a;11.75;100);`trade insert(09:32:00.000;`a;13.2;100);`trade insert(09:30:00.000;`b;100.75;100);`trade i...
Example: trade:([]time:`time$();sym:`symbol$();price:`float$();size:`int$()); `trade insert(09:30:00.000;`a;10.75;100);`trade insert(09:31:00.000;`a;11.75;100);`trade insert(09:32:00.000;`a;13.2;100);`trade insert(09:30:00.000;`b;100.75;100);`trade i...
For example: t:([] name:`Dent`Beeblebrox`Prefect; iq:98 42 126) select name, iq2:iq%100 from t where iq2>1 I would like to reference the newly created "iq2" column in the where clause, but the above command fails. How to modify it to make it work?
Kudos from
Kudos given to