Fórum Incluir parametros no SQL dinamicamente #291130

With DM.Qry1Plano do
begin
  Close;
  SQL.Clear;
  SQL.Add(´Select * From TabPlano´);
  SQL.Add(´Where NomePlano Like :PNome´);
  SQL.Add(´Order by NomePlano´);
  Parameters.ParamByName(´PNome´).Value (ou .asString) := Edit1.Text;
  Open;
end;

  SQL.Add(´Where NomePlano Like ´ + QuotedStr(Edit1.Text) +´¬´);
  SQL.Add(´Order by NomePlano´);
  Open;
end;