see my problem

To discuss Oracle Forms & Reports related technical issues.
Post Reply
mfa786
Posts: 51
Joined: Thu Jun 01, 2006 4:37 am
Location: Pakistan

see my problem

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
mfa786
Posts: 51
Joined: Thu Jun 01, 2006 4:37 am
Location: Pakistan

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests