数据行语法错误 [英] datarow syntax error

问题描述

HI，

我收到以下语句的语法错误为异常.

I am getting exception as syntax error for the below statement.

Dim partNums As DataRow()
partNums =BoxTable.Select("ORDER_ID =" + odrRow.Item("ORDER_ID").ToString +"RowNum<=1")

Run-time exception thrown : System.Data.SyntaxErrorException - Syntax error: Missing operand after ''RowNum'' operator.	

该boxtable中有12行，我试图通过添加ROWNUM< = 1来仅检索1行，但这给出了运行时异常.
上面代码中的错误

谢谢您.
Subhash G.

There are 12 rows in that boxtable, i am trying to retrive only 1 row by adding ROWNUM<=1, but it''s giving above run time exception.
wat''s the error in the above code

Thanks In Adance.
Subhash G.

推荐答案

如果这是所使用的确切代码，却不知道确切的错误，我想说的问题是在AND语句之前缺少空格最后一个字符串.

If this the exact code used and without knowing the exact error, I would say the problem is with the missing space before the AND statement in the last string.

这篇关于数据行语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！