query1.Close; query1.sql.Clear; query1.sql.Add('select sum(je) as je1,sum(zzje)as zzje1,sum(sl) as sl1 from xiaoshouz where rq=:d'); query1.ParamByName('da').AsDateTime:=date(); query1.open ; 执行后总是报'TABLE IS READ ONLY',这是为何? query1.requestlive:=true,请高手指教你的参数是da,但你引用写的是:d 这是笔误,将where后去除,报同样错,改成'select * from xiaoshouz'就不报错 因为你查询的数据中没有 da 这一项 改成 Delphi(Pascal) code: query1.sql.Add('select sum(je) as je1,sum(zzje)as zzje1,sum(sl) as sl1,da from xiaoshouz where rq=:da');
