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!

Total Sum of Leaves

Discussion in 'Oracle Forms and Reports' started by Salehin31, Nov 11, 2014.

  1. Salehin31

    Salehin31 Guest

    Hello frnz,

    I m a new comer of this forum. pls help me if I make any mistake. I m in an MIS executive of a private Co. I have to entry employees leave on our database. in attachment I upload a BMP file where u can get the interface & Data block in red font. Now I want the sum of SL/CL/EL on SL/CL/EL txt box.

    Pls help me

    --Salehin
     

    Attached Files:

  2. sambuduk

    sambuduk Forum Advisor

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

    Is it query form or Enterable form??

    If it is query form you can calculate (SL/CL/EL) from the table and assign those values to SL/CL/EL field in POST-QUERY trigger.


    You can zip and upload the .fmb file.


    Regards
    Sambasiva Reddy.K
     
    Salehin31 likes this.
  3. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Just to add to Sambasiva's post: in case of Enterable form, I suppose you could do same (but sum from Forms retrieved and modified records) in the WHEN-VALIDATE-RECORD trigger.
     
    Salehin31 likes this.