What am I doing wrong?

[Henry Martin]

I have a MySQL Database called contacts and a Table called contact.

On a form I have a dbGrid, an TSQLDatabase component a TDataSource component and a TMySQLQuery. To troubleshoot, I added a button and below is the OnClick

DBGrid1.DataSource := DataSource1;
mySQLQuery1.Active := FALSE;
mySQLQuery1.Prepare;
mySQLQuery1.SQL.Clear;
mySQLQuery1.Active;
mySQLQuery1.SQL.Add('SELECT * from Contact where LastName LIKE "S%"');
mySQLQuery1.ExecSQL;

If I type the select statement into the Object Inspector SQL it works fine.

What am I doing wrong?