Re: Need Help , Query using SQL Forms 2.3 (urgent)

Wow ! SQL*Forms 2.3 ! I've tried that once ! A very long time ago !

You'll have to create a view on your table, and then use the view as the base table for your block

Hope this helps

Karl

sAztro wignyo wrote in message ...
>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
>
>
>
Received on Fri Dec 12 1997 - 00:00:00 CET