Delphi nema veze sa SQL escape karakterima,
to je sve stvar u SQL jeziku.
ja to resavam jednom malom funkcijom koja radi savrseno sa MySQL serverom,
ali sigurno ce da radi i sa InterBase.
Code:
function EscapeSQLChars(str:string):string;
var
k:word;
escaped:string;
begin
escaped:=str;
k:=1;
while k<=length(escaped) do
begin
if escaped[k]='"' then
begin
insert('\',escaped,k);
inc(k);
end;
inc(k);
end;
k:=1;
while k<=length(escaped) do
begin
if escaped[k]='''' then
begin
insert('\',escaped,k);
inc(k);
end;
inc(k);
end;
k:=1;
while k<=length(escaped) do
begin
if escaped[k]='\' then
begin
insert('\',escaped,k);
inc(k);
end;
inc(k);
end;
EscapeSQLChars:=escaped;
end;
People who think they know everything tend to irritate those of us who do.