找不到sql语句,就写了 with ADOQueryFile do begin close; open; while not eof do begin m_id := FieldByName('module_id').AsString;
找到了 select t.module_id, t.kind, sum(t.total_count) as ss, sum(t.succ_count) as sc, count(*) as cc from WI_LOG_FILE_HANDLE t where t.optr_time between convert(char(8),getdate(),112)+substring(convert(char(8),getdate(),108),1,2)+ substring(convert(char(8),getdate(),108),4,2)+substring(convert(char(8),getdate(),108),7,2) and convert(char(8),(select dateadd(day,1,getdate())),112)+substring(convert(char(8),getdate(),108),1,2)+ substring(convert(char(8),getdate(),108),4,2)+substring(convert(char(8),getdate(),108),7,2)哪里有错呢
如果语句没问题的话
可能就是系统版本不支持的愿意了
你把代码贴出来看看
with ADOQueryFile do
begin
close;
open;
while not eof do
begin
m_id := FieldByName('module_id').AsString;
select t.module_id, t.kind, sum(t.total_count) as ss,
sum(t.succ_count) as sc, count(*) as cc
from WI_LOG_FILE_HANDLE t
where t.optr_time
between
convert(char(8),getdate(),112)+substring(convert(char(8),getdate(),108),1,2)+
substring(convert(char(8),getdate(),108),4,2)+substring(convert(char(8),getdate(),108),7,2)
and
convert(char(8),(select dateadd(day,1,getdate())),112)+substring(convert(char(8),getdate(),108),1,2)+
substring(convert(char(8),getdate(),108),4,2)+substring(convert(char(8),getdate(),108),7,2)哪里有错呢