查询中的语法错误.查询子句不完整. [英] Syntax error in query. Incomplete query clause.

问题描述

大家好，

下面的代码给出了以下错误:查询中的语法错误.查询子句不完整.

Hello everyone,

The following code is giving the following error:Syntax error in query. Incomplete query clause.

string commandstring = "SELECT MAX(ADX) FROM @out_table WHERE Date (between @strt_date AND @end_date)";
            OleDbCommand cmd = new OleDbCommand(commandstring, con);
            cmd.Parameters.AddWithValue("@out_table", out_table);
            cmd.Parameters.AddWithValue("@strt_date", dt_start);
            cmd.Parameters.AddWithValue("@end_date", dt_end);
            string val= (string)cmd.ExecuteScalar();

我找不到问题.请帮助我.

I cannot find the problem. please help me.

推荐答案

取出最后一组括号:

Take out the final set of brackets:

string commandstring = "SELECT MAX(ADX) FROM @out_table WHERE Date (between @strt_date AND @end_date)";

成为:

string commandstring = "SELECT MAX(ADX) FROM @out_table WHERE Date BETWEEN @strt_date AND @end_date";

在更正的查询后查找.

Find following the corrected query.

SELECT MAX(ADX) FROM @out_table WHERE Date between @strt_date AND @end_date

希望有帮助！

Hope this help!

使用此:

Use this:

string commandstring = "SELECT MAX(ADX) FROM @out_table WHERE [Date] between @strt_date  AND @end_date";
            OleDbCommand cmd = new OleDbCommand(commandstring, con);
            cmd.Parameters.AddWithValue("@out_table", out_table);
            cmd.Parameters.AddWithValue("@strt_date", dt_start);
            cmd.Parameters.AddWithValue("@end_date", dt_end);
            string val= (string)cmd.ExecuteScalar();

日期是保留名称，然后:
最好使用[Date]
并且不要使用括号

Date is a reserved name then:
It''s better to use [Date]
And do not use parenthesis

这篇关于查询中的语法错误.查询子句不完整.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！