求助高手

Question

执行下列代码时报错:"invalid use of keyword
                   token:year(dateadd(month,premonth,paydate))>?
                   line number:1"
请问怎么回事?
 
                      qry.Close;
                       qry.SQL.Clear;
                        qry.SQL.Add('select mainno from gpre');
                       qry.SQL.Add('where year(dateadd   (month,premonth,paydate))> :years');
                         qry.ParamByName('years').AsInteger:=strtoint(trimleft(cb1.Text));
                          qry.ExecSQL;
                           qry.Open;

Answer 1

year(dateadd   (month,premonth,paydate)) 是什么意思？

Answer 2

qry.SQL.Add(' where CAST(year(dateadd(month,premonth,paydate)) as INT)> :years');