1 2 Previous Next 15 Replies Latest reply: May 11, 2013 10:34 AM by ayadsufyan RSS

    can not delete the  last record ,  frm-40202 field must be entered

    ayadsufyan
      hi ,
      i have built a form which contain master and details blocks
      the problem is
      when i look for a record by executing query on on transaction serial and try to delete this record from the master block it gives me new serial for the transaction and when i try to save it, it says
      >frm-40202 field must be entered
      where this field is required and i cant save it
      although in another form when i delete from the master it gives me the previous record and it works properly

      the question is :
      why it gives a new serial when i delete the record ??
      if any one has any ideas pls help me


      thank u



      ------- the master block has a trigger when-create-record
      Declare
      >v_dummy number;
      Begin
      Select nvl(max(ERNT_NO),0) + 1
      >Into v_dummy
      From LM_RENT_EXPNMST
      >Where cmp_no = :LM_RENT_EXPNMST.cmp_no
      And brn_no = :LM_RENT_EXPNMST.brn_no
      >and fiscal_yr = :LM_RENT_EXPNMST.fiscal_yr;
      >:LM_RENT_EXPNMST.ERNT_NO := v_dummy;
      END;
      IF :PARAMETER.RNT_NO IS NOT NULL THEN
           :LM_RENT_EXPNMST.RNT_NO:=:PARAMETER.RNT_NO;
                :LM_RENT_EXPNMST.RNT_YR:=:PARAMETER.RNT_YR;
           :LM_RENT_EXPNMST.CUST_DESC:=:PARAMETER.RNT_ADESC;
      END IF;
        1 2 Previous Next