Page 1 of 1

see my problem

Posted: Tue Jun 13, 2006 3:40 am
by mfa786
hi master
sir see my problem
i am in form 1 in insert mod i need now party in feeding then i go party form with button press or i call party form
in party form i feed data when i save then system give me this error

FRM-40403 A calling form has unapplied changes. Save not allowed

i am in master detail form on master form key-commet i write this code

commit_form;
go_item('Detail.accid');
curser go in detail i feed or change in detail section but not save
and give me this error

FRM-40508 oracle error : unable to insert record


please give me idea

thank
aamir

Posted: Tue Jun 13, 2006 4:44 am
by mirza_rehan
Assalam-o-Alaikum

There is some different way for yours required task the easiest way just post when you call party form.

<b>POST;</b>

write this before call_form/open_form


take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Posted: Tue Jun 13, 2006 6:40 am
by mfa786
thank for your reply

brother i am use this code

begin
call_form('e:\fahim\partyformiqra');
:partyid :=:global.newparty;
if :partyid is not null then
select title into :partyname from partytable where partyid=:partyid;
end if;
go_item('repchq');
end;

after post use

begin
post;
call_form('e:\fahim\partyformiqra');
:partyid :=:global.newparty;
if :partyid is not null then
select title into :partyname from partytable where partyid=:partyid;
end if;
go_item('repchq');
end;

after this i push putton then system give me this error

FRM-40405 no change to apply
please give me idea

Posted: Tue Jun 13, 2006 6:44 am
by mirza_rehan
Its just informative message just check your party form data is saved or not???

take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Posted: Tue Jun 13, 2006 10:44 am
by admin
1- You need to put the following line in when-new-form-instance trigger to skip such messages,

:System.Message_Level := 25;

also check the online help to get information of other levels as well.

2- Please post threads with a relevant subject instead of generic like "see my problem" as it helps when members search some information.

Thanks