----- Original Message ----- 
From: "Lawrence Lustig" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 07, 2008 9:28 AM
Subject: [RBASE-L] - NOTE, VARCHAR, and LINEEND.



> No matter what I do, the VARCHAR field displays LINEEND characters in the 
> memo control where the user needs to see the actual line breaks.

Larry,

If you browse to the VarChar field and copy the contents of a field, then paste 
the contents into a text editor that displays the ASCII or HEX value for the 
TEXT of the VarChar, what represents the CrLf value..

Before you chase the Control as the issue, be sure the data contains the 
correct values.

If no Editor like that then this might substitute:

SELECT YourVarCharData INTO vcmd IND vin0 FROM +
YourVarCharFieldTable WHERE VarCharFieldPKFieldName = 'SomeUniqueValue'
SET VAR vlen = (SLEN(.vcmd))
SET VAR vsp TEXT = (CHAR(20))
SET VAR vasctxt TEXT = NULL
IF vlen > 0 THEN
  SET VAR vcount INTEGER = 1
  OUTPUT result.txt
  WHILE vcount <> .vlen THEN
    SET VAR vasctxt = (CTXT((ICHAR((SGET(.vcmd,1,.vcount))))))
    -- either of the following writes depending ?
    WRITE .vasctxt .vsp continue
    --WRITE .vasctxt
    SET VAR vcount = (.vcount + 1)
  ENDWHILE
ENDIF
OUTPUT SCREEN
RETURN



> Does anyone have any guidance for me?
> --
> Larry
>
>
> 


Reply via email to