DataSnap - how to change SELECT query to show different data?

In DataSnap, I have a server and client. In the client, I use this code to show data in a TDBGrid:
ClientDataSet1.CommandText := 'SELECT * from table_name WHERE autoid = 10';
ClientDataSet1.Open;
ClientDataSet1.Refresh;



But when I want to change this, the TDBGrid is not showing different data, it still shows data from my first code:
ClientDataSet1.CommandText := 'SELECT * FROM table_name WHERE autoid = 1';
ClientDataSet1.Open;
ClientDataSet1.Refresh;



How can I fix it?