Home » Developer & Programmer » Forms » forms -alert (oracle 10g Forms,windows)
forms -alert [message #587658] Mon, 17 June 2013 15:27 Go to next message
thelearner
Messages: 113
Registered: April 2013
Location: INDIA
Senior Member
Hi,

In alters I want to display a value dynamically.


like when deptno=10 came then it should dynamically displays the message like Department 10''.

when deptno=20 came then it should dynamically displays the message like Department 20''.
and.....

Thanks & Regards,
The Learner.

[Updated on: Mon, 17 June 2013 15:28]

Report message to a moderator

Re: forms -alert [message #587659 is a reply to message #587658] Mon, 17 June 2013 15:35 Go to previous messageGo to next message
Littlefoot
Messages: 19468
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
when deptno=10 came then ...

When does it come from?

Alert is an advanced MESSAGE feature, so that instead of simple acknowledging "OK" you have different options (Yes/No/Cancel, OK and stuff). So, when you create an alert, you decide which text to display. There's no problem in concatenating - as in your example - a department number to it. The question is: where does the department number come from? If you know how to fetch it, the rest is simple.
Re: forms -alert [message #587665 is a reply to message #587658] Mon, 17 June 2013 22:08 Go to previous messageGo to next message
lavkumar78
Messages: 9
Registered: June 2013
Location: delhi
Junior Member

not understad your question .
Re: forms -alert [message #588083 is a reply to message #587658] Thu, 20 June 2013 13:34 Go to previous messageGo to next message
thelearner
Messages: 113
Registered: April 2013
Location: INDIA
Senior Member
In deptno text_item, when I enter or dynamically select deptno is 10 then in alert dialog box it should shown like 'you selected Deptno:10'.

Re: forms -alert [message #589146 is a reply to message #588083] Tue, 02 July 2013 13:13 Go to previous message
thelearner
Messages: 113
Registered: April 2013
Location: INDIA
Senior Member
Finally i got the alert......
declare
	alrt varchar2(20);
 alrt2 varchar2(30):='You Selected Department No: '||:EMP.deptno;
begin
	set_alert_property('ALERT1',ALERT_MESSAGE_TEXT,alrt2);
	alrt:=show_alert('ALERT1');
END;


Previous Topic: Find an error line in PLSql
Next Topic: Search from db problemyp
Goto Forum:
  


Current Time: Wed Aug 20 10:32:27 CDT 2014

Total time taken to generate the page: 0.17563 seconds