Home » Developer & Programmer » Forms » Alert
Alert [message #80219] Mon, 26 August 2002 08:08 Go to next message
asma
Messages: 12
Registered: December 2000
Junior Member
I have an alert , I need to dispaly message and along with the message I need to
display the update by user and updated date.
These values are in the table and they are not dispalyed in the block.
how do I display the data from the table in the alert?

Thanks
Re: Alert [message #80240 is a reply to message #80219] Wed, 28 August 2002 10:14 Go to previous message
bobh
Messages: 3
Registered: August 2002
Junior Member
DECLARE
alert_id ALERT := Find_Alert('generic_alert');
dummy_var NUMBER;
alert_msg varchar2(80);
BEGIN
-- select table values e.g. into vtalbeuser and
-- vtabledate
-- and put them in your
-- alert message
alert_msg := 'Updated by: ' || vtableuser ||
' on ' || vtabledate
Set_Alert_Property(alert_id, ALERT_MESSAGE_TEXT, alert_msg);
-- now show the alert
dummy_var := Show_Alert(alert_id);
END;
Previous Topic: change default functionality of up and down arrow
Next Topic: Can Someone Look At My Procedure Please!
Goto Forum:
  


Current Time: Wed Feb 28 03:42:41 CST 2024