ADO连接ACCESS报错:操作符丢失(50分)

X

xlfdcn2002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #1

有如下语句,连接数据库为ACCESS2000:
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select shebname,count(*) ss from gdzcinput where 1=1 group by 1');
adoquery1.Open;
执行后提示:"语法错误(操作符丢失)在查询表达式'count(*) ss'中"
请问是何原因呀?如何解决呢?谢谢了

 

N

newsmile

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #2

adoquery1.SQL.Add('select shebname,count(*), ss from gdzcinput where 1=1 group by 1');//加个，

 

X

xlfdcn2002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #3

加,后显示:"试图执行的查询中不包含作为合计函数一部分的特定表达式'shebname'"

 

A

Avalon

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #4

select shebname,count(*) as ss from gdzcinput where 1=1 group by shebname

 

T

tianlove

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #5

^_^楼上的应该可以了吧?

 

X

xlfdcn2002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-18

• #6

可以了,谢谢大家