Re: Developer 2000 - Post Query ?
Date: 1996/04/18
Message-ID: <NEWTNews.829884972.8542.elric_dm_at_dialup.netvision.net.il>#1/1
In Article<3174EF9C.43C9_at_cpcuiia.org>, <mills_at_cpcuiia.org> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!psinntp!pubxfer.news.psi.net!usenet
> From: Ken Mills <mills_at_cpcuiia.org>
> Newsgroups: comp.databases.oracle
> Subject: Developer 2000 - Post Query ?
> Date: Wed, 17 Apr 1996 09:18:20 -0400
> Organization: American Institutes
> Lines: 8
> Message-ID: <3174EF9C.43C9_at_cpcuiia.org>
> NNTP-Posting-Host: 199.97.228.120
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 2.0 (WinNT; I)
>
> I have a master detail relationship and want to perform a
> calculation after "all" the detail records have been queried not
> after "each" detail record has been queried (not post-query on
> detail). Can I do it?
> --
> Ken Mills
> West Chester, PA.
> mills_at_cpcuiia.org
- what you ask for is NOT an easy task !!
- to handle the post-post query you can put your triggers in the key-entsqy and key-execqry don't forget to place the call to the real function, that is your new key-entqry will be
begin
enter_query ;
<your action here> ;
end ;
3) to work on the set of records fetched for ONE master record
(which is what I think you realy want) where your code in the post-query of the MASTER block, right after the populate_details
good luck and be very very cureful !
Yoram Z. Received on Thu Apr 18 1996 - 00:00:00 CEST