From: Peter Vroegop [mailto:[EMAIL PROTECTED]]
> Is it possible to do a query on the result set of a previous query. If so,
how do you go about it?
In some SQL dialects you can select query results directly into in-memory
temporary tables that you can then query on, or even construct a query that
runs as "from table, (select statement)", but not in Local SQL.
Some choices are
1/. Create a database table to hold your interim query results, with a new
unique name composed of the current user/process/SQL session, use it, and
destroy it afterwards
2/. Create a permanent table to hold your interim query results, and add
extra columns such as user, date and/or SQL session, so multiple SQL
sessions can use it simultaneously for such queries
3/. Use a front-end Filter on your dataset
4/. As in 3, but use an OnFilterRecord event to do the filtering instead
3 and 4 are easiest, but most network intensive. 1 or 2 are necessary if
you need to join your interim results to other tables.
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
