Re: Printing Memo Objects

[Scott Hitchcock <sbhitchc@HOTMAIL.COM>]

Jason,

You might try something like below....


begin-procedure main

encode '<013>' into $cr   !ascii Carriage Return
encode '<010>' into $lf   !ascii Line Feed

begin-select

var        &var

   let $var = translate(translate(&var,$cr,' '),$lf,' ')
   print $var              (+1,1)

from table
   where ....

end-select
end-procedure main


>From: Jason Wainwright <JasonW@LIMON.CO.ZA>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Printing Memo Objects
>Date: Wed, 5 Jan 2000 13:36:16 +0200
>
>Hi all
>
>From the Database I read a field that is varchar(250), only thing is, is
>that it has the enter character in it.  How do I print a string with these
>in, on screen (.SPF) it displays the two solid bars (extended acsii I
>think), when i print it it carriage returns.  The system is Win 95 and
>Sybase and Worbench v4.1.
>
>Any simple solutions?
>
>TIA

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com