Home » Developer & Programmer » Forms » showing message on several lines (forms 10g)
showing message on several lines [message #287515] Wed, 12 December 2007 08:25 Go to next message
emadnabil
Messages: 179
Registered: August 2007
Senior Member
Hii all

how can i show a message or alert message on several lines

suppose that this is my message that i want to show it to the user


invoice is closed please make a new invoce


i want to show it on two lines to be like that


invoice is closed
please make a new invoce


can i do this??
Re: showing message on several lines [message #287523 is a reply to message #287515] Wed, 12 December 2007 08:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Add a line feed character - CHR(10) - to your message.

MHE
Re: showing message on several lines [message #287669 is a reply to message #287515] Thu, 13 December 2007 01:56 Go to previous messageGo to next message
emadnabil
Messages: 179
Registered: August 2007
Senior Member
Thanks for your reply

but please show the shape of my message
how does it look

Re: showing message on several lines [message #287672 is a reply to message #287669] Thu, 13 December 2007 02:14 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You do know how to concatenate, don't you? Anyway, I created a small form and added an alert (my_alert) and a when-new-form-instance trigger with the following code:
DECLARE 
	the_text VARCHAR2(80) := 'A text with here '||chr(10)||'a line feed'; 
	al_id ALERT; 
	al_button Number; 
BEGIN 
	al_id := FIND_ALERT('MY_ALERT'); 
	SET_ALERT_PROPERTY(al_id, alert_message_text, the_text); 
	al_button := SHOW_ALERT( al_id ); 
END;
the code is a slight modification of the one found in the online help.

It will look like this:
/forum/fa/3583/0/
MHE
  • Attachment: orafaq1.jpg
    (Size: 5.53KB, Downloaded 973 times)
Previous Topic: i need help with the websites
Next Topic: Trigger Assistance
Goto Forum:
  


Current Time: Sun Feb 09 03:43:00 CST 2025