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!

How to replace variable by using IN operator?

Discussion in 'Oracle Forms and Reports' started by cssouza, Aug 4, 2011.

  1. cssouza

    cssouza Guest

    Hi,

    I'm creating a Forms where the user selects in the checkbox which products he wants to see. After the choice I should show all sales of that product, but the select doesn't recognize the variable after the IN operator, by example:

    SELECT product, price, quantity
    FROM sales
    WHERE product IN (vcProducts);

    Can anyone help me?

    Cris
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi, your requirement is not clear. you want to display items in LOV or List item.
    According to your description i understood it is LOV.

    What is vcProducts here????