Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sending a Line Return with PL/SQL

Re: Sending a Line Return with PL/SQL

From: John Blackburn <John.D.Blackburn_at_transport.qld.gov.au>
Date: Mon, 24 Jan 2000 10:59:31 +1000
Message-ID: <86g869$kd91@hp013.qdot.qld.gov.au>


Try using chr(10)

Courtney Wright <webmaster_at_hockeytowneinline.com> wrote in message news:3888c584$0$87621_at_news.voyager.net...
> I'm using Froms 4.5. I have a form setup that contains a multiple line
text
> box. Through code (programmatically), I'm populating the multiple line
text
> box with records from a table. I would like for each record to appear on
a
> different line. Here's the line that sets the info in the text box:
>
> > :LADOProject :=

:LADOProject||chr(13)||Get_Group_Char_Cell('RGRec.KOM',
> rn);
>
> I figured 'chr(13)' would start a new live as it does in VB, but in
Oracle,
> it just throws the square box in there (the square box your computer
> displays when the specified character isn't available in the font, you
> know...). How do I send a line feed?
>
> Thanks
> Courtney
>
>
Received on Sun Jan 23 2000 - 18:59:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US