字符串S1值为:
select * from abc where aa='123' and bb='234' and cc='456' and dd='567' and ee='678' (全是单引号)我怎样将上面的值变成select * from abc where aa=''123'' and bb=''234'' and cc=''456'' and dd=''567'' and ee=''678'' (全变成双引号)
补充:
单引号的数量和位置不确定
select * from abc where aa='123' and bb='234' and cc='456' and dd='567' and ee='678' (全是单引号)我怎样将上面的值变成select * from abc where aa=''123'' and bb=''234'' and cc=''456'' and dd=''567'' and ee=''678'' (全变成双引号)
补充:
单引号的数量和位置不确定
//用StringReplace,示例如下
StringReplace('abcd','b','e',[rfReplaceAll,rfReplaceAll]);
var
I:Integer;
begin
I:=Pos(Source,S);
if I>0 then begin
s:=Copy(S,1,I-1)+des+Copy(s,I+length(Source),Length(S)-I-length(Source)+1);
ReplaceStr(s,Source,des);
end;
end;
全部替换掉。
字符串S1值为:
select * from abc where aa='123' and bb='234' and cc='456' and dd='567' and ee='678' (全是单引号) 我怎样将上面的值变成 select * from abc where aa=''123'' and bb=''234'' and cc=''456'' and dd=''567'' and ee=''678'' (全变成双引号) 这一句要是在delphi中应该是不是双引号哦,应该是两个单引号才行哦
AdoQuery1.SQL.Text := select * from abc where aa=''123'' and bb=''234'' and cc=''456'' and dd=''567'' and ee=''678'' ;//里面应该都是单引号哦