Hi Group
In any RDBMS it is possible to build a query, and then use that query as the
basis of another query.
Very simple example:
open_d = (Select * from openday where opendate > 21/06/06)
week_d = (Select * from open_d where day = 'mon')
NB this is an EXAMPLE I have no interest in sorting anything by dates, I
just want information about the principle.
Is it possible to do this in Delphi 7?
Create a query, than use the results of that query as the basis of another?
IE: (I know this won't work, is there a way of making this work?)
myquery1:=tadoquery.create
myquery1.sql.add('sql stuff')
myquery1.active:=true
myquery2:=tadoquery.create
myquery2.sql.add('select * from myquery1')
myquery2.active:=true
As ever - TIA - Chris
Chris Moore
Computer Department
Brother Industries (UK) Ltd
_______________________________________________
Delphi-DB mailing list
[email protected]
http://www.elists.org/mailman/listinfo/delphi-db
