sql_plus中:
insert into dz_output_amount
select * from dz_return_amount;
成功!但在delphi5中,如下语句,却死活通不过!
with query1 do
begin
close;
sql.clear;
sql.add('insert into dz_output_amount');
sql.add('select dz_code,sum(input_sum) from dz_input_tbl1 group by dz_code order by dz_code');
prepare;
execsql;
end;
请高手指点一二!谢谢!
insert into dz_output_amount
select * from dz_return_amount;
成功!但在delphi5中,如下语句,却死活通不过!
with query1 do
begin
close;
sql.clear;
sql.add('insert into dz_output_amount');
sql.add('select dz_code,sum(input_sum) from dz_input_tbl1 group by dz_code order by dz_code');
prepare;
execsql;
end;
请高手指点一二!谢谢!
sql.add('select dz_code,sum(input_sum) from dz_input_tbl1 group by dz_code');
但是还是不行,提示:SQL命令未正确结束!
很多库比如interbase 不支持你这类的写法,后面的select 不能用order by
with query1 do
begin
close;
sql.clear;
sql.add('insert into dz_output_amount');
prepare;
execsql;
close;
sql.Clear;
sql.add('select dz_code,sum(input_sum) from dz_input_tbl1 group by dz_code order by dz_code');
prepare;
execsql;
end;
sql.add('select dz_code as 序号,sum(input_sum) as 合计 from dz_input_tbl1 group by dz_code');
有问题请发信息到我的E-mail:[email protected]