ORA-00936 Missing expressionsqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value & "' AND fv.Fund_id = " & Cells(j, 4).Value这是vba的一段,有错误,大概意思
来源:学生学帮网 编辑:学帮网 时间:2024/07/08 08:39:24
ORA-00936 Missing expression
sqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE
fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value
& "' AND fv.Fund_id = " & Cells(j, 4).Value
这是vba的一段,有错误,大
概意思从取fv表所有,f表的lipper_id,但要符合fv表和f表的主键fv.fund_id=f.fund_id,而且同时符合fv表的
Effective_date为cells(j,2).和Fund_id等于excel的cells(j,4)
请大侠赐教
FROM Fund_Values fv(就是这个地方你少个逗号)fund f
ORA-00936 Missing expressionsqlText = SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE fv.fund_id=f.fund_id AND fv.Effective_date = ' & Cells(j, 2).Value & ' AND fv.Fund_id = & Cells(j, 4).Value这是vba的一段,有错误,大概意思
ex
missing
missing
missing
MISSING .
missing
意大利语ora ma minu
欧美歌手rita ora外号?
tnsnames.ora是什么文件,
借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listener.log 的所在位置
Missing you,missing you,nothing but missing
Da ora in poi,voi tutti,ti
Oracle错误 ORA-12560如何解决
rita ora r.i.p 中英文歌词
双重时间 LA DOPPIA ORA怎么样
Rita Ora - How We Do flac
E'la mostra ora incisa sull' anello