请问一下 下面的这个错误，怎么解释呀？是我的sql有问题？还是数据库有问题的？(0分)

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-11

• #1

请问一下 下面的这个错误，怎么解释呀？是我的sql有问题？还是数据库有问题的？


project project2.exe raised exception class edbengineerror with
message 'general sql error.

ORA-00936：缺少表达式.process stopped.use step or run to continue

 

Z

zqw0117

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-11

• #2

你是不是忘了给Query属性赋sql语句的字符串值？

 

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-11

• #3

附值了呀~~

 

寒

寒与凉

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-11

• #4

把你的SQL语句贴出来

 

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-11

• #5

'select equipment.chrequipment ,testrecord.intave,testrecord.dttest from testrecord,equipment where equipment.chrequipment in ['+sb+'] and testrecord.idequipment=equipment.idequipment and testrecord.dttest>datetime1 and testrecord.dttest<datetime2 order by testrecord.dttest'