在delphi中下面第6行中a,b 为变量,这样写有没有错误?with ADOQuery1 do
begin
close;
sql.Clear;
sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz ');
sql.Add(' where sjbh like a+b+'%');
sql.Add(' order by sth');
open;
end;
begin
close;
sql.Clear;
sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz ');
sql.Add(' where sjbh like a+b+'%');
sql.Add(' order by sth');
open;
end;
sql.Add(' where sjbh like '''a+b+'%''');Sql Server:
sql.Add(' where sjbh like "'a+b+'%"');