E
e_ceo
Unregistered / Unconfirmed
GUEST, unregistred user!
运行错误为“ORA-00937:非单组分组函数”代码如下，
去掉count(*)或者直接以字符串代替绑定的变量Time，运行都会正常
String strsql :=‘select count(*) from ti_c_olcomwork where
exectime >= to_date
strTime,'YYYY-MM-DD HH24:MI:SS') and exectime <=sysdate ’;
ADOQuery1.SQL.Add(strsql);
ADOQuery1.Parameters.ParamByName("strTime").Value="2003-07-01 00:00:00";
ADOQuery1.Open();
去掉count(*)或者直接以字符串代替绑定的变量Time，运行都会正常
String strsql :=‘select count(*) from ti_c_olcomwork where
exectime >= to_date
strTime,'YYYY-MM-DD HH24:MI:SS') and exectime <=sysdate ’;ADOQuery1.SQL.Add(strsql);
ADOQuery1.Parameters.ParamByName("strTime").Value="2003-07-01 00:00:00";
ADOQuery1.Open();