any1可以在查询表达式'Non Technical（insuffi）IS NOT NULL'中解析语法错误（缺少运算符）。 [英] Can any1 resolve Syntax error (missing operator) in query expression 'Non Technical (insuffi) IS NOT NULL'.

问题描述

查询表达式中的语法错误（缺少运算符）'非技术（insuffi）IS NOT NULL'。



i有.xls文件我正在从中读取数据我的数据集

但是当我读到它时会在上面的查询中给出以上异常



SELECT * FROM [+ SheetName +$] WHERE + ColumnToCheckNotNull +IS NOT NULL;



其中SheetName = SHEET1，ColumnToCheckNotNull ='非技术（insuffi）'

Syntax error (missing operator) in query expression 'Non Technical (insuffi) IS NOT NULL'.

i have .xls file i am reading data from that to my dataset
but when i read it gives above exception on below query

"SELECT * FROM [" + SheetName + "$] WHERE " + ColumnToCheckNotNull + " IS NOT NULL";

where SheetName = SHEET1, ColumnToCheckNotNull= 'Non Technical (insuffi)'

推荐答案

WHERE+ ColumnToCheckNotNull +IS NOT NULL;



其中SheetName = SHEET1，ColumnToCheckNotNull ='非技术（insuffi）'

WHERE " + ColumnToCheckNotNull + " IS NOT NULL";

where SheetName = SHEET1, ColumnToCheckNotNull= 'Non Technical (insuffi)'

SELECT * FROM [+ SheetName +

"SELECT * FROM [" + SheetName + "

WHERE Non Technical（insuffi）IS NOT NULL



在WHERE之后你需要一个正确的语法条件，

解析器无法识别短语Non Technical（insuffi） ）



干杯，

Edo

WHERE Non Technical (insuffi) IS NOT NULL"

Right after the WHERE you need a properly syntaxed condition,
the parser does not recognize the phrase "Non Technical (insuffi)"

Cheers,
Edo

这篇关于any1可以在查询表达式'Non Technical（insuffi）IS NOT NULL'中解析语法错误（缺少运算符）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！