Re: Same record, different blocks
Date: Fri, 10 Jul 1998 11:23:45 -0400
Message-ID: <35A63201.D2173A66_at_dc.dynares.com>
Hi Michael,
Don't do either.
[Quoted] Make one block with multi record view. The summary has a display number
of 0 (the default, follows the block definition) and the detail columns
has a display number of 1. The coordination then happens totally
automatic ... when focus is moved in the summary list, the details
automaticly shows the detail values of that current record.
I think this is part of the demos to Forms .....
- Peter H. Larsen
Michael Toomey wrote:
>
> in forms 4.5, what is the best way to do the following:
>
> on the same canvas, i'd like to have two different blocks, with the
> same base table, displaying the same records. one will display
> multiple records (summary info) and the other one record (detail info).
>
> as you scroll in the multiple record block, selecting a new
> record puts the details in the detail-level block.
>
> i have this working fine by defining a relation between the
> two, with the ROWID being the join criteria. scrolling through
> the records in the summary displays the same record in
> the detail.
>
> problem is, i can't modify the data in the detail level, because
> the record is locked from being in the summary level.
>
> do i need the detail level to be a control block? i definitely
> prefer for it to be a base-table block, so i can use all the
> default functionality in forms.
>
> or, do i need to build the summary level block (multiple
> records) with a pl/sql procedure?
>
> i guess i don't completely understand the way locking works,
> since i would not be seeing this problem if i had this split
> into two forms. of course i don't wanna do that either.
> making the summary-level block "query only" has no effect.
>
> any help?
> -mt
-- Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria Email: plarsen_at_dc.dynares.com (please remove the nospam from the header when replying to this email) The above views are my own and does not reflect the views of my employer.Received on Fri Jul 10 1998 - 17:23:45 CEST