[delphi-en] Sql Query problem

[schoemanshaun]

Hi.The problem i am experiencing is a follows, I run a query, the 
result is
displayed in the dbgrid, i run the report and the result is fine.
I then empty the clientdataset, a second query is run but the result 
displays
the records from the previous query.Even though i empty the 
clientdataset and run a new
query, as soon as i refresh the clientdataset it displays the result 
of the previous query.

Any ideas? 

    dmmanchq.ClientDataSet1.Refresh;
    dbgrid1.Refresh;
    dmmanchq.rvpManchq.Open;
    dmmanchq.rvpManchq.SelectReport('reports',False);
    dmmanchq.rvpManchq.Execute;
    dmmanchq.rvpManchq.Close;
    dmmanchq.ClientDataSet1.EmptyDataSet;