Re: Re: Sql Query problem

Hi,
what about

query.close;
query.sql.add('select whatever from wherever')
query.open;
dbgrid1.Refresh;

Regards,
Johan

----- Original Message -----
From: schoemanshaun
To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
Sent: Wednesday, May 09, 2007 10:45 AM
Subject: [delphi-en] Re: Sql Query problem

Hi

Thanks for the advice but it is not helping?
Any other ideas?

Thanks

--- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, Alireza Alef - G
<dadash_ninja...> wrote:
>
> You have to close you dataset after closing the clientdataset and
thet reopen them
>
> schoemanshaun <schoemanshaun...>
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]
>

__________ NOD32 2255 (20070509) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com

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

Messages in this topic (0) Reply (via web post) | Start a new topic

.