DM.ADOQueryRen.Close; DM.ADOQueryRen.SQL.Clear; DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm)); // ~~~~~~~~~~~~~~~~~~~ DM.ADOQueryRen.Open; // ~~~~``
DM.ADOQueryRen.Close; DM.ADOQueryRen.SQL.Clear; DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm)); // ~~~~~~~~~~~~~~~~~~~ DM.ADOQueryRen.Open; // ~~~~``
bm为integer 赋给它的值也是
DM.ADOQueryRen.Close; DM.ADOQueryRen.SQL.Clear; DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm)); // ~~~~~~~~~~~~~~~~~~~ DM.ADOQueryRen.Open; // ~~~~``
to yansea(思宏) : 你的方法没有用 问题依旧
bm := DM.ADOTBInfo.FieldValues['编码'];
DM.ADOQueryRen.Close; DM.ADOQueryRen.SQL.Clear; DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码='+IntToStr(bm)'); DM.ADOQueryRen.Open;DM.ADOTBZZ.Locate('编码',bm,[]);
to sunwk(sunwk) : 那个表BQQ里的编码也是integer的啊
bm := DM.ADOTBInfo.FieldValues['编码'];
DM.ADOQueryRen.Close; DM.ADOQueryRen.SQL.Clear; DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=:bm1'); //你试一下吧: dm.adoqueryren.parameters.parambyname('bm1'):=bm; DM.ADOQueryRen.ExecSQL; DM.ADOTBZZ.Locate('编码',bm,[]); <--这里出问题,提示“参数bm没有默认值”
DM.ADOQueryRen.SQL.Clear;
DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm));
// ~~~~~~~~~~~~~~~~~~~
DM.ADOQueryRen.Open;
// ~~~~``
DM.ADOQueryRen.SQL.Clear;
DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm));
// ~~~~~~~~~~~~~~~~~~~
DM.ADOQueryRen.Open;
// ~~~~``
赋给它的值也是
DM.ADOQueryRen.SQL.Clear;
DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=' + QuotedStr(bm));
// ~~~~~~~~~~~~~~~~~~~
DM.ADOQueryRen.Open;
// ~~~~``
你的方法没有用
问题依旧
DM.ADOQueryRen.Close;
DM.ADOQueryRen.SQL.Clear;
DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码='+IntToStr(bm)');
DM.ADOQueryRen.Open;DM.ADOTBZZ.Locate('编码',bm,[]);
那个表BQQ里的编码也是integer的啊
DM.ADOQueryRen.Close;
DM.ADOQueryRen.SQL.Clear;
DM.ADOQueryRen.SQL.Add('Select sum(dhpt) as dqpt,sum(dqhg) as dqhg from BQQ where 编码=:bm1');
//你试一下吧:
dm.adoqueryren.parameters.parambyname('bm1'):=bm; DM.ADOQueryRen.ExecSQL; DM.ADOTBZZ.Locate('编码',bm,[]); <--这里出问题,提示“参数bm没有默认值”
用了你的方法了
还是错,不过变成“标准表达式的类型不匹配”了可是类型应该是完全匹配的