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

[Quoted] It's been a few years since I wrote Forms 2.3 also. But wanted to add this point. If you use a view for your base table you may have problems with inserts and/or updates. I don't recall if Ver 2.3 has trigger points for "on_insert/update/delete" but in ver 3.0 and beyond you'd use these to apply modifications to the "target table" masked by the view.

Ken

Karl E. Jørgensen <kjorg_at_msn.com> wrote in article <uOccau1B9GA.198_at_upnetnews04>...
> 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 19 1997 - 00:00:00 CET