当我运行以下查询时，它显示错误 [英] when i run the below query it shows the error

问题描述

我在MsAccess数据库中的查询如下;



SELECT [Sch_Date]&，&[Session]&，&[Course] AS Message

来自Tb_SCh_TIme_Table;







输出如下;



消息

2/25 / 2013,1，ARPA



当我输入在Windows应用程序的设计页面上面的查询显示错误



sql =SELECT [Sch_Date]&，&[Session]&，&[Course] AS消息

FROM Tb_SCh_TIme_Table;



无效的表达式''，''

;除外

;例外





当我在设计视图中以ms访问类型输入上述查询时，它运行并提供输出。

My query as follows in MsAccess Database;

SELECT [Sch_Date] &"," & [Session] &"," & [Course] AS Message
FROM Tb_SCh_TIme_Table;



Output as follows;

Message
2/25/2013,1,ARPA

when i type the above query in design page in windows application shows error

sql = "SELECT [Sch_Date] &"," & [Session] &"," & [Course] AS Message
FROM Tb_SCh_TIme_Table";

Invalid expression term '',''
; excepted
; excepted


when i type the above query in ms access in Design view it runs and gives the output.

推荐答案

sql =SELECT [Sch_Date] +''，''+ [Session] +''，''+ [Course] as Message

FROM Tb_SCH_TIme_Table ;

尝试这个......

sql="SELECT [Sch_Date] + '','' + [Session] + '','' + [Course] as Message
FROM Tb_SCH_TIme_Table";
try this one...

这篇关于当我运行以下查询时，它显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！