You have to close you dataset after closing the clientdataset and thet reopen 
them

schoemanshaun <[EMAIL PROTECTED]> wrote:                                  
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;
 
 
     
                       

       
---------------------------------
 Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit now.

[Non-text portions of this message have been removed]

Reply via email to