一个SQL查询问题(100分)

W

whflzy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #1

sSQL:=Format('SELECT %S mydate,SUM(mysum) FROM sell WHERE mydate>=%T and
mydate<=%T GROUP BY %S mydate', [sSQL,date1,date2,sSQL1]);
mydate是日期类型。这个语句怎么改？%T应该改为什么？还有什么变通的办法。

 

H

hbezwwl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #2

在SQL语句中使用参数就行了.

 

S

Sindbad

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-11

• #3

改成：sSQL:=Format('SELECT %S mydate,SUM(mysum) FROM sell WHERE mydate>=''%S'' and
mydate<=''%S'' GROUP BY %S mydate', [sSQL,FormatDateTime('yyyy-MM-dd', date1),FormatDateTime('yyyy-MM-dd', date2),sSQL1]);

 

L

liu_sir

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #4

不明白你的意思,用
sSQL='SELECT '+sSQL+' mydate,SUM(mysum) FROM sell WHERE mydate>='''+date1+''' and
mydate<='''+date2+''' GROUP BY mydate'不可以吗?

 

W

whflzy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-11

• #5

接受答案了.