----- Original Message -----
From: "Lawrence Lustig" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 07, 2008 12:25 PM
Subject: [RBASE-L] - Re: NOTE, VARCHAR, and LINEEND.
>
> My question remains, though -- what's the correct syntax to set a VARCHAR
> column to the concatenation of two TEXT fields with a line end between the
> values:
>
> UPDATE Table SET VarcharCol = (TextCol + CHAR(10) + TextCol)
>
> UPDATE Table SET VarcharCol = (TextCol + CHAR(13) + TextCol)
>
> UPDATE Table SET VarcharCol = (TextCol + CHAR(13) + CHAR(10) + TextCol)
>
> UPDATE Table SET VarcharCol = (TextCol + (CVAL("LINEEND"))+ TextCol)
>
> Any insight to share?
Per my other missive, just edit one field using the built in editor,
deleting whatever LineEnd separates the values, replacing it with a HardReturn,
which from my testing results in 0D 0A, or CHAR(13) + CHAR(10).
Bring up that data in your form and see what the result is.
If it is still a NoGo, then just do the brute force method and delete the
control, save the form and re-insert the control again, just to be certain
there is nothing goofey going on there.
I just did a quick test of my own, concantenating 3 text columns into a
VarChar, then displaying the data in a DBMemo and the display is correct, but I
can't speak to any speed issues as I don't have a large dataset to go by.
> --
> Larry
>
>
>
