关于" contains method not supported "的错误 &

Question

我运行下面的脚本:

store_code = ["AH0001","AH0003","AH0004","AH0005"]
typestr(store_code)
temp_store_tbl = table(store_code)
select * from shared_skx_tt6 where store_code in (exec * from temp_store_tbl)
select * from shared_skx_tt6 where store_code in (store_code)

出现错误:

Contain method not supported.

Answer 1

在DolphinDB中，变量名和字段名不能相同，因此需要重命名变量store_code

脚本需要修改:

store_code1 = ["AH0001","AH0003","AH0004","AH0005"]
typestr(store_code)
temp_store_tbl = table(store_code)
select * from shared_skx_tt6 where store_code in (exec * from temp_store_tbl)
select * from shared_skx_tt6 where store_code in (store_code1)