Registriert seit: 4. Feb 2003
Ort: Hannover
2.032 Beiträge
Delphi 12 Athens
|
Re: TQuery variabel
16. Jan 2010, 12:01
Delphi-Quellcode:
begin
SQLString:= StringReplace(Edit2.Text,' #',' _',[rfReplaceAll]);
SQLString:= StringReplace(SQLString,' ..',' %',[rfReplaceAll]);
SQLString:= StringReplace(SQLString,char(34),' ',[rfReplaceAll]);
Edit1.Text:= SQLString;
with Query1 do
begin
Active:=False;
SQL.Clear;
SQL.Add(' Select * from gesamt3 where feld002 Like %:text% ');
ParamByName(' text').asString := SQLString;
Active:=True;
end;
end;
|
|
Zitat
|