1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle form Tree View Problem

Discussion in 'Oracle Forms and Reports' started by aadityainpccs, Jan 12, 2013.

  1. aadityainpccs

    aadityainpccs Active Member

    Messages:
    52
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    New delhi (INDIA)
    Hello,
    Please anyone could suggest me that problem in master detail oracle form having tree view control.For better understanding I have attached an image file about my problem.

    for this problem I have make a record_group which has query--
    SELECT 1 , level , ARTICLE_MSTR.ATRTICLE_TYPE,ARTICLE_DTL.ARTICLE_NAME , NULL , to_char( ARTICLE_DTL.ARTICLE_NO)
    FROM ARTICLE_MSTR LEFT JOIN ARTICLE_DTL ON ARTICLE_MSTR.ARTICLE_ID=ARTICLE_DTL.ARTICLE_ID
    CONNECT BY prior ARTICLE_DTL.ARTICLE_NO = ARTICLE_MSTR.ARTICLE_ID
    START WITH ARTICLE_MSTR.ARTICLE_ID=1

    But it is not working
    Please give me solution and if you have any better optimized solution to my problem, to also.
    Thank You
    regards
    aaditya.
     

    Attached Files: