DELETE_RECORD changes the Record_status to 'NEW' HELP ME
FormsOct 8 2009 — edited Nov 24 2009Hi Gurus,
I have only one record in my block.
I am trying to delete it and it executed all the Triggers like PRE-DELETE, KEY-DEL-RECORD succesfully. But when I save it, it gives FRM-40202.
This only happens when I try to delete the last record in the bloc, because, the DELETE-RECORD built in in the KEY-DEL-REC changes the record status in the block to NEW and when I try to save the form there is a required filed, which causes the Save to faile.
But if there are more than 1 record in the block this is not a problem.
Gurus, please help me as I have to promote this code ASAP to production.
Thanks in advance.