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 forms

Discussion in 'Oracle Forms and Reports' started by mohammedasif, Jan 8, 2014.

  1. mohammedasif

    mohammedasif Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    100
    I have doubt in oracle forms 10g
    i have 2 tables t_bill1 and t_stock, i have developed t_bill1 in frontend and from their the entry will be saved into the database......
    T_bill1 t_stock
    prod_id prod_id
    prod_name prod_name
    qty qty

    my question is that...
    If i enter my quantity as 5 in t_bill1 then it should automatically reduce 5 items in the stock table......................

    I used post_insert trigger
    begin
    update t_stock
    set qty=(qty-:t_bill1.qty)
    where prod_id=:t_bill1.prod_id;

    end;

    please give me response guys
     
  2. mohammedasif

    mohammedasif Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    100
    i found answer by myself, if anyone needs the solution reply back