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 use the " BETWEEN AND" Operator using Two list value?

Discussion in 'Oracle Forms and Reports' started by Panneerselvam, Jan 18, 2014.

  1. Panneerselvam

    Panneerselvam Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    For example: List Item 1 -> Supplier1 value : 1 Min Value. I will give the Initial value for first list item box is '1'
    Supplier2 value :2
    Supplier3 value :3
    Supplier4 .....Etc.
    List Item 2 -> Supplier1 value : 1
    Supplier2 value :2
    Supplier3 value :3
    Supplier4 .....Etc. Max Value. I will give the Initial value for Second list item box is '50'
    For above example. I will give supplier1 for first list and supplier10 for second list item.
    In that example. I want to select the particular suppliers in between two list item.

    Example: SELECT * From Suppliers WHERE Suplr_suplr_id BETWEEN list_item1 AND list_item2;

    How to get the list value and how to use by using "BETWEEN AND" Operator.
    How to write the coding for this concept. Please tell suggestion.
    Advance Thanks to all.
     
  2. mohammedasif

    mohammedasif Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    100
    according to me, you cant fetch proper answer for you query. the query which you have used is mostly correct but in the list_item1 and list_item2 you have to place values
    eg:
    SELECT * From Suppliers WHERE Suplr_suplr_id BETWEEN 1 AND 8;


    for now this is my suggestion, please elaborate your problem