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

You're right. Updates/deletes/inserts on such a view would be a problem. And according my memory (which may be wrong) - where was I .... ehrm.... SQL*Forms 2.3 did NOT have any On-Insert/On-Update/On-Delete triggers.

But the 'using-a-view-method' should still work ok for you if all you want to do is *look* at the data :-)

--
Karl
Oracle Certified DBA

Ken Friday wrote in message <01bd0c9a$37fb60c0$8859a8c0_at_04653>...


>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

>> >

>> >

>> >

>>

>>

>>