Result sets of a TQuery feed into another TQuery

Result sets of a TQuery feed into another TQuery

Post by Alan » Wed, 04 Aug 1999 04:00:00



Hi,

I have a Query1 which gives result of a select * from table1;
How do I feed this result into another TQuery(ie Query2} such as :

insert into table2 (field1, field2,...)
{result set of Query1}

of course the fields 1,2,.. types are compatible with the result set of
Query1

 
 
 

Result sets of a TQuery feed into another TQuery

Post by Bob Stub » Thu, 05 Aug 1999 04:00:00


Howdy:

Can't you use the tCursor.add() method?

HTH.

Bob



Quote:>Hi,

>I have a Query1 which gives result of a select * from table1;
>How do I feed this result into another TQuery(ie Query2} such as :

>insert into table2 (field1, field2,...)
>{result set of Query1}

>of course the fields 1,2,.. types are compatible with the result set of
>Query1