devxlogo

Delphi Queries and SQL

Delphi Queries and SQL

Question:
I am trying to perform multiple queries, and to speed things up I want to perform a query on the result of a previous query. Is there an easy way to do a Select * from QUERYNAME without moving the resulting records from the query to a new table and then performing a select on the new table?

In other words, can you use a query as the object of an SQL select statement, and if so, how?

Answer:
Sorry, but no, you can’t perform a query on a query because the TQueryobject is expecting a peristent data store from which to grab information. By its very nature, a query result is not persistent.

devx-admin

Share the Post: