Need help filtering a dataset

Posted by Fatih ÇAKIR on December 25, 2008

Hi. I'm making a database program on delphi using ms sql and I have a problem. For example I received a dataset using an adostoredproc. Then I want to filter this dataset using sql commands.
But I can filter an adostoredproc only using filter option (adostoredproc.filter). But it is very limited. I know that can form the new dataset using another adostoredproc but doesn't receiving
the same data again and again slow the network traffic? So I'm thing to copy this dataset
to a local pardox table and to filter it with a TQUERY component. Is it stupidly? Is there another way which I don't know?