开发者

Exception in a Query

开发者 https://www.devze.com 2023-02-19 04:37 出处:网络
can anyone tell me why this query throws an error \"No value given for one or more required parameters.\"

can anyone tell me why this query throws an error "No value given for one or more required parameters."

Select Status from [Viewer$] WHERE 开发者_StackOverflow中文版 SlNo-Viewer < 4 ... I'm trying to query an excel file and this query is not working with that....Please help....


If SlNo-Viewer is name of a single field, the minus character in the field name is interpreted as the minus operator and it's trying to subtract field called Viewer from field called Slno.

Try this instead:

Select [Status] from [Viewer$] WHERE [SlNo-Viewer] < 4
0

精彩评论

暂无评论...
验证码 换一张
取 消