Re: Forms 5.0 Master/Detail blocks
From: <czetie_at_nospamus.oracle.com>
Date: Thu, 07 May 1998 15:45:09 -0700
Message-ID: <35523975.7842_at_nospamus.oracle.com>
Date: Thu, 07 May 1998 15:45:09 -0700
Message-ID: <35523975.7842_at_nospamus.oracle.com>
> > Why not? And one way to do this is to base the block on a
> > FROM Clause Query.
> >
>
> Is this a Forms 5.0 new feature? Could you be more specific?
> TIA
> Igal
>
Yes, this is a new feature in 5.0. Rather than basing the block
[Quoted] on a table or view as you did in the past, set the Block Data
Source Type property to FROM Clause Query. Enter your query
as the data source. Create data items to correspond to the columns
returned by the query. The query is simply the table join you
want, e.g. (SELECT empno, ename, deptno, dname from emp, dept
where etc.). Check the online help for more details.
regards, Received on Fri May 08 1998 - 00:45:09 CEST