N
nido
Unregistered / Unconfirmed
GUEST, unregistred user!
adoquery1.sql中已有语句
select top 1 <column> from tabel
adoquery2.sql中已有语句
select <column1>,datepart(yy,arameters),datepart(qq,arameters),count(<column1>)
from tabel
where datepart(yy,<column>)=datepart(yy,arameters),datepart(qq,<column>)=datepart(qq,arameters)
group by <column1>
<column>为datetime;
Unit中procedure 中的语句
adoquery1.Open;
adoquery2.Close;
adoquery2.Parameters.ParamValues['Parameters']:=(adoquery1.Fields[0].Value);
adoquery2.Open;
adoquery2.First;
问题是:
在object inspector中adoquery2.active可为true;
但在Unit中adoquery2.open处出错。提示为 语法或冲突
请问为什么??
select top 1 <column> from tabel
adoquery2.sql中已有语句
select <column1>,datepart(yy,arameters),datepart(qq,arameters),count(<column1>)
from tabel
where datepart(yy,<column>)=datepart(yy,arameters),datepart(qq,<column>)=datepart(qq,arameters)
group by <column1>
<column>为datetime;
Unit中procedure 中的语句
adoquery1.Open;
adoquery2.Close;
adoquery2.Parameters.ParamValues['Parameters']:=(adoquery1.Fields[0].Value);
adoquery2.Open;
adoquery2.First;
问题是:
在object inspector中adoquery2.active可为true;
但在Unit中adoquery2.open处出错。提示为 语法或冲突
请问为什么??