Re: Need Help , Query using SQL Forms 2.3 (urgent)
Date: 1997/12/02
Message-ID: <881046079.14140_at_dejanews.com>#1/1
I imagine that your form contains a multi-row block whose base table is table A. To show the summary information of your query:
i) create a control block (block that does not have a base table) if one does not already exist.
ii) create the display fields to house a, min(b), avg(c) etc. Note that these fields would normally appear beneath the multi-row block.
iii) Create the following KEY-ENTQRY trigger associated with eth multi-row block:
ENTER_QUERY; SELECT DISTINCT(A), MIN(B), AVG(C)
INTO :BCONTROL.DISVAL , :BCONTROL.MINVAL , :BCONTROL.AVGVAL FROM TABLE_A
GROUP BY .... or, if you use EXECUTE_QUERY statements, place this statement immediately afterwards.
Regards,
Pete Cardin
In article <EKHnnA.65K_at_news.arco.com>,
"sAztro wignyo" <saztro_at_hotmail.com> wrote:
>
> Dear oracle news readers
>
> I have some problem using SQL Forms 2.3
> this is the case :
> I want to make some quey on my forms...
> that quey show the result of calculation...
> in SQL Pus i can write
>
> "Select Distinct a,min(b),avg(c),max(d)
> from tablename
> group by a "
>
> but i don't know how to write this in my SQL*Forms program
>
> Thanks for your help
>
> Arief
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Tue Dec 02 1997 - 00:00:00 CET