Re: Insert Multiple Lines into long or varchar2 field

Thanks for your help.

I think it's something to do the application itself. Right now I tried to migrate application from Unify database into Oracle. The application works fine with the Unify database but it doesn't work with Oracle.

I tried to updated the record using chr(10) and when the application gets the newest updated record back and shows in the multiple lines. The wired things is when the application updates the record again and retrieved the data back in the single line again in the application.

Alan

Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br> wrote in message news:<5jv3d053rmb9q71hurs6gj0s9jjbiqorf2_at_4ax.com>...
> On 17 Jun 2004 10:18:42 -0700, wangxianlg_at_yahoo.com (Alan) wrote:
>
> >How can I insert Multiple Lines into long or varchar2 field and when
> >application gets data back also in Multiple Lines format.
> >
> >Thanks in advance
> >
> >Alan
>
> CHR(10) breaks the line.
> Depends on the application to retrieve correctly. On Oracle Forms, just set the property "multiline"
> to yes.
Received on Fri Jun 18 2004 - 07:54:10 CDT