Refresh data with same criteria as last QBE

[giga]

Hi, user select some data using QBE. How can I refresh data with same criteria?
How can I save the SQL and variables in time of executing QBE?
What is the preffered way how to do it - I need general procedure which is able to do it.
I try enter QBE .. execute QBE but it isn;t work fine ...

Regards V.

 

[Marco Kalter]

That's easy. If you call TOracleDataSet.Refresh (or use the Refresh button of a navigator) the QBE criteria will remain.

 

[giga]

Thanks you very much. Unfortunatelly I forgot to say taht I used TOracleDataSet connected via TDataSetProvider to TClientDataSet. I do the QBE query that way: I set OracleDataset to QBEMode and do QBE. Then I open the connected ClientDataset. The ClientDataset read the data from the OracleDataSet and then OracleDataSet is closed.
Is there any way how to use it in this situation (because I have to used TclientDataSet due to in memory sorting and because that the old application used it).
It's possible on soem toracledataset event save query which will be performed?

Thanks & Regards

 

[Marco Kalter]

If the TOracleDataSet is closed then the QBE information is cleared. You would have to save this information and restore it later, but I have no example for this or experience with this.