【搞定】[请求]这个出错信息啥意思？**

crosbychina

前台出错信息：
ExecuteSQL error: The executeUpdate method must not return a result set.
后台日志：
2007-7-27 16:10:50 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: ExecuteSQL error: The executeUpdate method must not return a result set.
java.lang.Exception: ExecuteSQL error: The executeUpdate method must not return a result set.
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
        at java.lang.Thread.run(Thread.java:595)

crosbychina

---------------------------
X3 Studio
---------------------------
运行系统初始化的时候发生异常：ExecuteSQL error: The executeUpdate method must not return a result set.

类型：Exception。
---------------------------
确定   
---------------------------

crosbychina

在这里报错

crosbychina

procedure TZLNLPG.ProcAfterFlowFinish(Sender: TObject; Command: TFlowFinishCommand);
var
   query1:Tquery;
begin
   query1:=Tquery.Create(nil);
   try
      query1.ConnectionString:='DATABASEURL=Biz:\GYSGL\SMIS_DATABASE.Database';
      query1.CommandText:='SELECT COUNT(PGDH) COUNT FROM SCNLPGZB WHERE PGDH='''+Command.FlowControl.Flow.ID+'''';
      query1.Execute;
      if query1.FieldByName('COUNT').AsInteger =0 then
         begin
              query1.CommandText:='INSERT INTO SCNLPGZB (PGDH,GYSBH,GYSMC,GYSSZD,LJBH,LJMC,LJGG,PGZT) SELECT PGDH,GYSBH,GYSMC,GYSSZD,LJBH,LJMC,LJGG,0 FROM ZLNLPGZB WHERE ZLNLPGZB.PGDH ='''+Command.FlowControl.Flow.ID+'''';
              query1.Execute;
         end;
   finally
      query1.Free;
   end;
end;

lisb

query1.CommandText:='SELECT COUNT(PGDH) COUNT FROM SCNLPGZB WHERE PGDH='''+Command.FlowControl.Flow.ID+'''';
      query1.Open;

yancm

用query1.open
query1.excute执行没有返回数据集的SQL