这个access的sql有错误！(0分)

gujianchun · 2006-11-22

ADOQuery1.Close;
ADOQuery1.Sql.Clear;
ADOQuery1.Sql.add('select sum(hjje) as 茶水 from FW_JSGL where XM=菊花茶');
ADOQuery1.Open ;

pgx01234 · 2006-11-23

ADOQuery1.Sql.add('select sum(hjje) as 茶水 from FW_JSGL where XM='''+'菊花茶'+'''');

焰火使者 · 2006-11-23

kidneyball · 2006-11-23

最近好象很多写SQL条件不加字符串引号的贴子.....

dangde · 2006-11-23

用一个函数嘛，专门给字符串加引号的

粒粒小 · 2006-11-25

ADOQuery1.Sql.add('select sum(hjje) as 茶水 from FW_JSGL where XM='+#39+'菊花茶'+#39);

萨奇马 · 2006-11-25

ADOQuery1.Sql.add('select sum(hjje) as 茶水 from FW_JSGL where XM='''菊花茶'''');

www.stonebloom.com 欢迎光临

yinligang_111 · 2006-11-25

支持pgx01234的解释
运行一下看看

ChrisMao · 2006-11-30

ADOQuery1.Sql.add(Format('select sum(hjje) as 茶水 from FW_JSGL where XM=%s', [QuotedStr('菊花茶')]);