Querying a Query

Neil and Chris

Delphi Developer

Tue, 27 Jun 2000 03:00:00 GMT

Querying a Query

I want to query some tables using a TQuery, and then query the resulting
data set using another TQuery. How do I do this? The dataset from the first
TQuery will not have a table name that I can use in the SQL statment for
the second TQuery.

Neil McCrossin
Brisbane, Australia
n...@gil.com.au

Bill Todd (Tea

Delphi Developer

Wed, 28 Jun 2000 03:00:00 GMT

Re:Querying a Query

Use the BatchMove component to save the result set from the first
query to a table.

Bill

(Sorry but TeamB cannot answer support questions received via email.)
(To send me email for any other reason remove .nospam from my address.)

Brian Bushay Tea

Delphi Developer

Wed, 28 Jun 2000 03:00:00 GMT

Re:Querying a Query

Quote

>I want to query some tables using a TQuery, and then query the resulting
>data set using another TQuery. How do I do this?

You can save the result of the first query to a table using
DbiMakePerminate.

DbiMakePermanent(query1.handle, 'temp.db',true);
--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Neil and Chri

Delphi Developer

Wed, 28 Jun 2000 03:00:00 GMT

Re:Querying a Query

Brian Bushay TeamB <BBus...@DataGuidance.com> wrote in article
<34c6ffa5.82751...@forums.borland.com>...

Quote

> >I want to query some tables using a TQuery, and then query the resulting
> >data set using another TQuery. How do I do this?

> You can save the result of the first query to a table using
> DbiMakePerminate.

> DbiMakePermanent(query1.handle, 'temp.db',true);
> --
> Brian Bushay (TeamB)
> Bbus...@DataGuidance.com

But isn't there some way of doing it all in memory?

Neil McCrossin
n...@gil.com.au

Brian Bushay Tea

Delphi Developer

Thu, 29 Jun 2000 03:00:00 GMT