When I try to insert table A into table ttable A is the select result from a table:table t is an self-defined tablet:( sym:(); exp_month:(),strike_code:();strike:();exp_year:();size:();ex_time:();ex:();trigger:());table A and table B have the same columns`t insert AI meet the error:Possibly this error refers to columns that can’t be aligned for R,R orK,Kany hints for that?? thanks!
I noticed an error in the declaration of t:"exp_month:(),strike_code:();"Note that the column names are seperated by , (comma) and not ;(semicolon).That would result in a table which has no strick_code column. You canverify this by issuing “meta t”.I also suggest that when lookin at strange errors: Get the meta of thetables you try to operate over to verify that types and column namescan associate as expected.On 13 Juli, 21:10, Iris <fanny…> wrote:> When I try to insert table A into table t>> table A is the select result from a table:>> table t is an self-defined table>> t:( sym:(); exp_month:(),strike_code:();strike:();exp_year:();size:> ();ex_time:();ex:();trigger:());>> table A and table B have the same columns>> `t insert A>> I meet the error:> Possibly this error refers to columns that can’t be aligned for R,R or> K,K>> any hints for that?? thanks!</fanny…>
Thanks:)On Jul 14, 7:06 am, H?kan <lindqvist.h…> wrote:> I noticed an error in the declaration of t:>> “exp_month:(),strike_code:();”>> Note that the column names are seperated by , (comma) and not ;> (semicolon).> That would result in a table which has no strick_code column. You can> verify this by issuing “meta t”.>> I also suggest that when lookin at strange errors: Get the meta of the> tables you try to operate over to verify that types and column names> can associate as expected.>> On 13 Juli, 21:10, Iris <fanny…> wrote:>> > When I try to insert table A into table t>> > table A is the select result from a table:>> > table t is an self-defined table>> > t:( sym:(); exp_month:(),strike_code:();strike:();exp_year:();size:> > ();ex_time:();ex:();trigger:());>> > table A and table B have the same columns>> > `t insert A>> > I meet the error:> > Possibly this error refers to columns that can’t be aligned for R,R or> > K,K>> > any hints for that?? thanks!</fanny…></lindqvist.h…>