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!

lov not work

Discussion in 'Oracle Forms and Reports' started by mist, Nov 30, 2013.

  1. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi all,

    I have 2 blocks(blockname,forecastcontrol(non-database)), 5 items are there in two blocks with having lov's , my requirement is that when i select any one of the lov , display all other 4 records , so, write below code for 1st lov(organisation_code) item the all other 4 records are displays it is fine and same code i wrote for another 2nd(fiscal_year) item it not shows records, except first record(organisation_code), what is the problem for this can any one please help me.

    Thank you
    shiva
     

    Attached Files:

  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Mist,

    Replace ' finalstr ' assignment with below code It may work.

    finalstr := 'where ORGANIZATION_CODE = ''' ||:FORECASTCONTROL.ORGANIZATION_CODE||'''';



    Regards,
    Sambasiva Reddy.K