Re: First query as input of subsequent query. How?

Article View: comp.lang.pascal.delphi.databases

Article #20

Back to comp.lang.pascal.delphi.databases Previous Next

#20

From: Markku Nevalainen
Date: Wed, 04 Aug 1999 00:00

18 lines
1152 bytes

btm wrote:
> 
> 
> but this didn't work... How can I access the result of the
> first query from within the SQL statement of a second query???
> 
> Thanks for any help!
> 

You can save the results from the first Query1 to a disk file, and 
do the second Query against this table:

  dbiMakePermanent(Query1.Handle, 'C:\TEST.DB',True);

If you have multi user environment, there may be some problems where
you direct that temporary table, but it should work also there.

Markku Nevalainen

Technical Details

Message-ID: <37A81570.5076@iki.fi>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <37a74737.1659755@news.spectraweb.ch>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,455a5e39a9565868
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,455a5e39a9565868
X-Google-Attributes: gid115d96,public
From: Markku Nevalainen <mne@iki.fi>
Subject: Re: First query as input of subsequent query. How?
Date: 1999/08/04
Message-ID: <37A81570.5076@iki.fi>
X-Deja-AN: 508709831
Content-Transfer-Encoding: 7bit
References: <37a74737.1659755@news.spectraweb.ch>
Content-Type: text/plain; charset=us-ascii
Organization: Oy Ab
Mime-Version: 1.0
Reply-To: mne@iki.fi
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database

Reply to Parent Message