Re: Forms 5.0 Master/Detail blocks

igal_at_healthstreet.com wrote:
>
> > Yes, this is a new feature in 5.0. Rather than basing the block
> > 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,
> >
>
> Thanks for the enlightenment. It's realy an important feature.
> Pitty you still can't perform DML on those blocks.

In fact, you can. You can specify *separately* to use the underlying table for DML while using the FROM Clause Query for fetching. Again, new in 5.0. Received on Fri May 08 1998 - 21:47:32 CEST