潮
潮州人
Unregistered / Unconfirmed
GUEST, unregistred user!
在paradox7中定义字段Payoff为Date类型，现在想查询年度为2000年的数据，我是这样做的，但出错。
With Query1 do
begin
Close;
SQL.Clear;
SQL.Add (Select count(*) from tblCheckWork where Extract(YEAR From Payoff)=Year_Dele);
Prepare;
Open;
end;
With Query1 do
begin
Close;
SQL.Clear;
SQL.Add (Select count(*) from tblCheckWork where Extract(YEAR From Payoff)=Year_Dele);
Prepare;
Open;
end;