Re: Inserting carriage returns in text field
From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Mon, 19 Apr 1999 17:25:22 -0600
Message-ID: <371bbb39.0_at_news.cadvision.com>
Date: Mon, 19 Apr 1999 17:25:22 -0600
Message-ID: <371bbb39.0_at_news.cadvision.com>
Add a chr(13) || chr(10) to wherever you want to have a newline
-- Terry Dykstra (TeamPS) Canadian Forest Oil Ltd. jim wrote in message <7fg1kl$3ga_at_faile.nidlink.com>...Received on Tue Apr 20 1999 - 01:25:22 CEST
>hey all!
> I'm back with another newby question that that "wonderful" oracle
>documentation fails to address.
>the problem is this: One large text field displays the concatenated
results
>of a query, but it all crunches together. I can add spaces or whatever
>between entries, but what I would really like to do is add a carriage
return
>or better yet, a blank line, between entries.
>
>This is what I am doing:
>
>PROCEDURE GET_MESG IS
>
>today varchar2(300) :='';
>
>CURSOR Today_mesg is
>SELECT MESSAGE
>FROM MAIN.CAL_INFO
>WHERE MAIN.CAL_INFO.CAL_DATE = :INP_DATE
>and MAIN.CAL_INFO.WHO_SEE = 2;
>
>BEGIN
>
>GO_ITEM('MESG');
>CLEAR_ITEM;
>
>for new in Today_mesg loop
>today := today ||' *** '|| new.message;
>end loop;
>
>:MESG := today;
>
>GO_ITEM(:GLOBAL.CUR_ITEM);
>END;
>
>Any help would be greatly appreciated. Please reply to wyma69_at_nidlink.com
>
>thanx
> Jim.
>
>