在ADOQuery中传递参数出错,奇怪! (50分)

G

gy606

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-21

• #1

ADOQuery.sql.text:='select field1,fiel2 from table where field3>'
传递参数D后Open结果正确.
*******
ADOQuery.sql.text:='select field1,sum(fiel2) from table where field3> group by field1'
传递参数D后Open不能执行.提示"group by 错误"

 

K

kalituo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-21

• #2

用了group by field1后，条件中就只能用field1来限制了

 

S

sunhood

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-24

• #3

group by 后的字段，不能在select后

 

G

geminii

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #4

Adoquery1.Parameters.ParamByName('D').DataType := ftstring(相应类型)
Adoquery1.Parameters.ParamByName('D').Value := 变量值
以上语句必须在对delphi打补丁sp1后,Ado打补丁sp2后，才能正常运行

 

G

gy606

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-30

• #5

接受答案了.