这一句子放入QUERY内为啥不行? (20分)

9

94132195

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-08

• #1

query.add('select mark,name,sum(quantity) from out_ware group by mark);
在后台sql server内执行完全可以，如果我要把以上选择的数据存入到别一个临时
表里那又该怎么处理呢?下一次把这个临时表的数据放入另一个QUERY里处理能行吗?

 

T

tank007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-08

• #2

query.add('select mark,name,sum(quantity) from out_ware group by mark,name');

 

小

小小豆豆龙

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-08

• #3

query.add('select mark,sum(quantity) from out_ware group by mark);
or
query.add('select mark,name,sum(quantity) from out_ware group by mark,name);

 

9

94132195

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-08

• #4

如果我要把以上选择的数据存入到别一个临时表里那又该怎么处理呢?

 

L

LanHer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #5

query.add('select mark,name,sum(quantity)as quantity into #Temp from out_ware group by mark,name');
execsql;

 

C

catfox

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #6

若SQL语句有错，将语句复制到SQLSERVER的查询分析器中运行有出错信息了

 

C

cqwang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #7

create table #temptable(field1,field2...)
insert into #temptable
select mark,name,sum(quantity) from out_ware group by mark,name
操作临时表和操作普通表并没两样
你可以select * from #temptable
select 语句用query1.open执行
insert update等用execsql;
你用的是query1.sql,add(...)，是不是你的query1里面已经有了sql语句了？记得先clear;

 

B

beckzd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-10

• #8

up

 

9

94132195

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-02-16

• #9

接受答案了.