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

Question

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?