请教sql语句的问题。

[yl_yz]

我在database画板中执行
insert into dcsr(ch,je,jsrq) SELECT ch, sum(je), jsrq FROM j200112 GROUP BY ch,jsrq ORDER BY ch,jsrq；
语句可以。
为什么我在程序中用
ls_sql="insert into dcsr(ch,je,jsrq) "&
+"SELECT ch, sum(je), jsrq "&
+"FROM "+is_table &
+" GROUP BY ch,jsrq"&
+" ORDER BY ch,jsrq"
execute immediate :sqls using sqlca;
就不行。
请各位帮忙看看，我用的是access数据库。

[ldk]

ls_sql="insert into dcsr(ch,je,jsrq) "&
+"SELECT ch, sum(je), jsrq "&
+"FROM "+is_table &
+" GROUP BY ch,jsrq"&
+" ORDER BY ch,jsrq using sqlca"

execute immediate :ls_sql;

[nielinjie]

建议print ls_sql检查一下。

[linda_gao]

you can check sqlca.sqlerrtext

[tiantianpb]

sqlca.autocommit=true试试