Adoquery don't work (i think)

[mbdelphi]

Hi

Ihave an AdoQuery with the following query:

select * from customers where name like :name

on a edit and speedbutton hi have

  ADOQuery1.Parameters.ParamByName('name').value := edit1.Text+'%';
  ADOQuery1.ExecSQL;

Why the adoquery don't make the query?

Thank's in advance.

Marco Branco

[mbdelphi]

I think that with this adoquery i can make many kind of filters, with multiple parameters.

Any sugestion?

Marco

[Norrit]

ExecSQL isn't for select statements, you need Open

[kdalibor]

  ADOQuery1.Parameters.ParamByName('name').value := edit1.Text+'%';
  ADOQuery1.ExecSQL;

Why not use SQL instead. Maybe something like this:

ADOQuery1.DisableControls;
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:= 'SELECT * FROM Customers WHERE Name LIKE ' + QuotedStr(edit1.Text + '%');
ADOQuery1.EnableControls;
ADOQuery1.Open;