OraFAQ Forum: Forms » no delete child record

Home » Developer & Programmer » Forms » no delete child record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

no delete child record [message #174491]

Mon, 29 May 2006 07:10

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master
sir
i have master delete form
i have problem in delete when child record
sir in key-commit event i have this code

begin
IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN
if :drbal='' or :crbal='' then
clear_form(no_commit);
go_block('chartofacc');
next_record ;
go_item('drbal');
else
/*(no_commit) and exit_form(no_validate) it seems */
commit_form;
go_block('chartofacc');
next_record ;
go_item('drbal');
end if;
elsif :SYSTEM.FORM_STATUS = 'DELETE'
THEN
DELETE ACCBAL WHERE ACCID=:chartofacc.ACCID;
go_block('chartofacc');
end if;
end;

but my system not delete the child record when i press delete button
and when i delete master record system give me error found mactching record in detail
please give me idea how i delete child record

thank

aamir

Report message to a moderator