Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HELP ME..SQL*Forms 3.0...NEED HELP FAST!

HELP ME..SQL*Forms 3.0...NEED HELP FAST!

From: Marcel <mdeneef_at_caiw.nl>
Date: 1997/07/15
Message-ID: <33CBCFD4.EF498A8A@caiw.nl>#1/1 







--------------FEE5D211E2C23E91924CC599
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit





Can anyone help me?



I develop programs in SQL*Forms 3.0 for a short while. At this time a
would like to have the


following functionality but I don't have a solution for making it
work.....Can YOU give me an


answer on how to go about.....Thanks.



Functionality:



One Base-Table block with Base-Table "TAB_A". Definition of  "TAB_A" is
as follows:


       "TAB_A" -[<column1>,<column2>]
       with primary key (column1,column2)

The table has the following records
        ---> ("ZZ","abc"),("ZZ","def"),("ZZ","ghi") and ("YY","jkl") .





In SQL*Forms I would like to see only <column1> with the number of
occurences of the


value of <column1> in this table.


e.g.

       Value           Count
       --------           ---------
        ZZ                  3
        YY                 1





My problem is that using a base-table (and using a POST-QUERY trigger)
the only


thing I can get so far is :


       Value           Count
       --------           ---------
        ZZ                  3
        ZZ                  3
        ZZ                  3
        YY                 1






As you are a real Oracle programmer/crack you'll probably see that I
would like to use


some kind of een SELECT DISTINCT when using QUERY in this Base Table.



The $100.000,- question is......HOW?!




--------------FEE5D211E2C23E91924CC599
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





<HTML>

<B><FONT SIZE=+1>Can anyone help me?</FONT></B>




<P>I develop programs in SQL*Forms 3.0 for a short while. At this time

a would like to have the


<BR>following functionality but I don't have a solution for making it work.....Can

YOU give me an


<BR>answer on how to go about.....Thanks.




<P>Functionality:




<P>One Base-Table block with Base-Table "<B>TAB_A</B>". Definition of&nbsp;

"<B>TAB_A</B>" is as follows:



<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "<B>TAB_A</B>" -[&lt;<B>column1</B>>,&lt;<B>column2</B>>]

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; with primary key (<U>column1,column2</U>)




<P>The table has the following records

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---> ("<B>ZZ</B>","<B>abc</B>"),("<B>ZZ</B>","<B>def</B>"),("<B>ZZ</B>","<B>ghi</B>")

and ("<B>YY</B>","<B>jkl</B>") .



<P>In SQL*Forms I would like to see only &lt;column1> with the number of

occurences of the


<BR>value of &lt;column1> in this table.

<BR>e.g.

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Count</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

---------</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

3</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

1</B><B></B>



<P>My problem is that using a base-table (and using a POST-QUERY trigger)

the only


<BR>thing I can get so far is :




<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Count</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

---------</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

3</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

3</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

3</B>


<BR><B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

1</B>


<BR>&nbsp;




<P>As you are a real Oracle programmer/crack you'll probably see that I

would like to use


<BR>some kind of een SELECT DISTINCT when using QUERY in this Base Table.




<P>The $100.000,- question is......HOW?!

<BR>&nbsp;

<BR>&nbsp;</HTML>




--------------FEE5D211E2C23E91924CC599--

Received on Tue Jul 15 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US