why it gives a new serial when i delete the record ??if any one has any ideas pls help me
Select nvl(max(ERNT_NO),0) + 1
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;
IF :PARAMETER.RNT_NO IS NOT NULL THEN
No matter what I do I always get "INSERT" status of a record. By the way my test case was made on 126.96.36.199 version.
:dept.loc := 'X'; clear_message; message(:system.record_status);pause;
Now when you delete the record you should get the INSERT status of the record. If so it definitely means you are doing some manipulation on the record you are trying to delete. From this point on you will have to pinpoint the offending code.