Sunny wrote:
> Hi,
>
> It does not work as I tried it way back.
>
> Thank You
> Regards
> sunny
>
> On Nov 29, 5:23 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Sunny wrote:
>>> Hi All,
>>> I have a unique problem I will be greatful if any one can help me out.
>>> I have 3 blocks, A, B and C. I have created the blocks and their
>>> relationships using wizard. All htese blocks are based on tables.
>>> Relationships:
>>> 1. Block A is the master of block B (detail)
>>> 2. Block B is the master of block C (detail)
>>> Block A is a form layout (single record), block B is tabluar
>>> layout(multi records) with scroll bar and block B is tabluar
>>> layout(multi records). with a scroll bar
>>> All my block are on single canvas and window. No matter whether we put
>>> them in different canvas and windows or stacked canvas or tab canvas,
>>> but till the problem persistes.
>>> Lets assume:
>>> Block A --> showing single record
>>> Block B --> having 4 multi records
>>> Block C --> a single record for 3rd record in the Block B
>>> Problem/Issue.
>>> Assume that I have queried (F11 and Ctr + F11) on Block A and it is
>>> now showing as my our assumpation (as stated above)
>>> 1. When I click on scroll bar or 2nd, 3rd, 4th ... record in block B
>>> then it clears all the records in block B and block C. This clearing
>>> does not happen when I click on the first record of block B.
>>> 2. Lets assume after querying I clicked on first record of block B and
>>> moved down to 3rd record in block B. Now we can see the corresponding
>>> record in block C for the 3rd record in the block B.I click on the
>>> record in the block C then I clicked on the 4th record in block B, then
>>> it clears block B and block C. This clearing does not happen if I click
>>> back on the same cooresponding record in block B.
>>> This is happeing in "ON-CLEAR-DETAILS" trigger which is created at
>>> module/form level when we create master detail relationships. The
>>> tirgger calls "Clear_All_Master_Details" program unit. This is the code
>>> from "Clear_All_Master_Details" program unit which is cleaing
>>> currel := Get_Block_Property(trigblk, FIRST_MASTER_RELATION);
>>> WHILE currel IS NOT NULL LOOP
>>> curdtl := Get_Relation_Property(currel, DETAIL_NAME);
>>> IF Get_Block_Property(curdtl, STATUS) <> 'NEW' THEN
>>> Go_Block(curdtl);
>>> Check_Package_Failure;
>>> Clear_Block(NO_VALIDATE);
>>> IF :System.Block_Status <> 'NEW' THEN
>>> RAISE Form_Trigger_Failure;
>>> END IF;
>>> END IF;
>>> currel := Get_Relation_Property(currel, NEXT_MASTER_RELATION);
>>> END LOOP;
>>> I have not wrote any custom code or triggers as of now. All I have
>>> created is 3 block with master detail relationship using wizard.
>>> I do not want to modifiy any seed code of oracle applications. I really
>>> appricate any kind of help regarding this issue..
>>> Thank You
>>> Regards
>>> sunnyRecreate the blocks. If that doesn't do it ... post the version.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show quoted text -
If you can, without violating company policy, send me the form
off-line.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Nov 29 2006 - 17:55:34 CST
