SQL question CRLF

[Damon Pillinger]

Hi Ruslan and serge.

Don't worry I figured it out

UPDATE [table] SET field_name = "line1<crlf>line2"

Replace <crlf> with chr(13) only and it works fine.

Thanks

Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Wednesday, 13 July 2005 6:58 PM
To: valentina at lists.macserve.net
Subject: Re: SQL question CRLF

On 7/13/05 9:44 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> Something like this
> 
> UPDATE [table] SET field_name = "line1<crlf>line2"
> 
> Where <crlf> is a chr(13)+chr(10)
> 
> So when I do a select and put it into an editfield I get
> Line1
> Line2
> 
> Thanks

Ok Damon,

Sergey will add this feature into SQL Parser.
Somehow we did miss it.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina