Form Question [message #85063] |
Fri, 28 May 2004 00:36 |
Mukesh Kumar saini
Messages: 1 Registered: May 2004
|
Junior Member |
|
|
Respected sir/mam,
1.I have a problem in save the record.I am using commit_form bulitin.when I click on the save button in my form.Two times it show the alter like frm-40405 no save apply.and then commit.i donot want to these type of message.I am handling these through on-message trigger and on-commit.
:system.message_level= 5.
but problem just same.pls tell me what I do?
2.I am open report from form passing some parameter,but it also run time parameter at run time .I donot want it run time when I am it from forms.for this purpose we paramform=no/yes,how to use it.
mukesh saini
|
|
|
Re: Form Question [message #85064 is a reply to message #85063] |
Fri, 28 May 2004 00:45 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Mukesh,
To suppress any error message make use of On-Error trigger in Forms.
Begin
If Error_Code = 40405 Then
NULL;
ElsIf Error_Code =41026 Then
Message('I: List of values not available for this field.',NO_ACKNOWLEDGE) ;
-----
End If;
Please write the Question #2 a bit clearly as I am unable to understand your Problem.
Regards
Himanshu
|
|
|
Re: Form Question [message #85076 is a reply to message #85063] |
Sat, 29 May 2004 13:48 |
shahzad
Messages: 17 Registered: February 2002
|
Junior Member |
|
|
create a form level trigger ON-ERROR and place this code
if error_code=40401 then
null;
end if;
i hope it will solve ur problem
|
|
|
Re: Form Question [message #85086 is a reply to message #85064] |
Mon, 31 May 2004 17:52 |
dek sugi
Messages: 2 Registered: May 2004
|
Junior Member |
|
|
For question no: 2
Try this:
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'Report_Parameter',TEXT_PARAMETER,Form_Parameter_YouWantToPass);
-- to hide form parameter in report set 'NO'
Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');
Run_Product(REPORTS, Path_To_YourReportName, SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
END;
regards,
dek sugi
|
|
|