EDatabaseError 错误 AdoQuery1:Field 'XXXX' not found ( 积分: 30 )

adoquery1连接数据库正常&nbsp;但运行提示&nbsp;EDatabaseError&nbsp;错误&nbsp;AdoQuery1:Field&nbsp;'人口总数'&nbsp;not&nbsp;found&nbsp;的错误<br><br>方法一：<br>adoquery1.Active设为false<br>其SQL&nbsp;的String&nbsp;List&nbsp;Editor中为：select&nbsp;sum(人数)&nbsp;人口总数&nbsp;from&nbsp;人口表<br>然后&nbsp;有代码：<br>var&nbsp;&nbsp;<br>people:string;&nbsp;&nbsp;<br>&nbsp;...&nbsp;&nbsp;<br>adoquery1.Active:=false;&nbsp;&nbsp;<br>adoquery1.Active:=true;&nbsp;&nbsp;<br>people:=adoquery1.FieldByName('人口总数').AsString;<br>//执行到这里&nbsp;提示EDatabaseError&nbsp;错误&nbsp;AdoQuery1:Field&nbsp;'人口总数'&nbsp;not&nbsp;found&nbsp;&nbsp;<br>&nbsp;&nbsp;<br><br><br>方法二（此方案OK&nbsp;但不知为何&nbsp;方法一&nbsp;行不通）：<br>adoquery1.Active设为false<br>代码：<br>var&nbsp;&nbsp;<br>people:string;&nbsp;&nbsp;<br>...&nbsp;&nbsp;<br>adoquery1.Close;&nbsp;&nbsp;<br>adoquery1.SQL.Clear;&nbsp;&nbsp;<br>adoquery1.SQL.Add('select&nbsp;sum(人数)&nbsp;人口总数&nbsp;from&nbsp;人口表');&nbsp;&nbsp;<br>adoquery1.Open;&nbsp;&nbsp;<br>people:=adoquery1.FieldByName('人口总数').AsString;&nbsp;&nbsp;<br>&nbsp;...&nbsp;&nbsp;<br><br>我按方法二执行&nbsp;却是OK的&nbsp;不知原因在哪里&nbsp;谢谢大家的指点