大家帮我看一下这句sql为什么出错

Question

strhao:=dm1.adoQuery.fieldbyname('hao').AsString;
        dm1.adoInfoquery.Active:=false;
        dm1.adoInfoquery.SQL.Clear();
        dm1.adoInfoquery.SQL.Add('select * from '+strCurrTable+' where hao='+strhao);
        dm1.adoInfoquery.Open();

Answer 1

strhao:=dm1.adoQuery.fieldbyname('hao').AsString;
        dm1.adoInfoquery.Active:=false;
        dm1.adoInfoquery.SQL.Clear();
        dm1.adoInfoquery.SQL.Add('select * from '+strCurrTable+' where hao='''+strhao+'''');
        dm1.adoInfoquery.Open();

Answer 2

同意genphone_ru(改行去学VC)