Using a TMyquery as a source for a Tmyquery

sjorford · Post by **sjorford** » Thu 21 Sep 2006 19:09

Can I do this? I'd like to query a remote dataset, then further reduce the result set later on. I can't see any obvious way to do this using BDS2006. With a Tquery a would have used another Tquery as the datasource for another tquery. Or do I use Mastersource in some way?

Thanks!

Antaeus · Post by **Antaeus** » Fri 22 Sep 2006 13:33

It is not possible to do this with two TMyQuery components anyway. If both dataset objects are in the same application you can try to use TMyQuery as source dataset and TVirtualTable as destination dataset. If both dataset objects are in different applications you can try to use TClientDataset as a destination dataset.