This discussion is archived
1 2 Previous Next 15 Replies Latest reply: May 11, 2013 8:34 AM by ayadsufyan RSS

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

ayadsufyan Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points