Home » Developer & Programmer » Forms » How to display alert message in Forms 9i.
How to display alert message in Forms 9i. [message #267677] Fri, 14 September 2007 03:47 Go to next message
kelvinora
Messages: 16
Registered: September 2007
Location: India
Junior Member
Hi
How to display alert message in Forms 9i.
The alert box is same as Javascript alert?
or anyother things?
Thanks,
Re: How to display alert message in Forms 9i. [message #267678 is a reply to message #267677] Fri, 14 September 2007 03:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this OraFAQ topic.
Re: How to display alert message in Forms 9i. [message #267688 is a reply to message #267678] Fri, 14 September 2007 04:50 Go to previous messageGo to next message
kelvinora
Messages: 16
Registered: September 2007
Location: India
Junior Member
I had tied to display alert message in the form..

But it shows FRM-41039: Invalid alert ID 0 - my alert(s) do not display ..

The below is my function..

FUNCTION ALERT_SHOW(message VARCHAR2,showmsg VARCHAR2)
RETURN NUMBER IS alert_no NUMBER;
BEGIN
Set_Alert_Property(message,ALERT_MESSAGE_TEXT,showmsg);
alert_no:= show_alert(message);
RETURN alert_no;
END;

The trigger code is as follows..

DECLARE
ALERT_ID NUMBER;
BEGIN
ALERT_ID:=ALERT_SHOW('ERROR','hai');
raise form_trigger_failure;
END;
Re: How to display alert message in Forms 9i. [message #267695 is a reply to message #267688] Fri, 14 September 2007 05:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you create an alert whose name is 'ERROR'?
Re: How to display alert message in Forms 9i. [message #267699 is a reply to message #267695] Fri, 14 September 2007 05:17 Go to previous messageGo to next message
kelvinora
Messages: 16
Registered: September 2007
Location: India
Junior Member
No.. How to create that?
I thought this is an string message
Thanks
Re: How to display alert message in Forms 9i. [message #267710 is a reply to message #267699] Fri, 14 September 2007 06:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Under the "Alerts" node of the Object Navigator.
Re: How to display alert message in Forms 9i. [message #267724 is a reply to message #267710] Fri, 14 September 2007 06:32 Go to previous message
kelvinora
Messages: 16
Registered: September 2007
Location: India
Junior Member
Hi It s working
Thanks
Previous Topic: Want to import some tables from Oracle to SQL Server
Next Topic: problem during saving the form
Goto Forum:
  


Current Time: Sat Dec 10 01:28:58 CST 2016

Total time taken to generate the page: 0.07611 seconds