Here's the situation: I altered the structure of a large table to turn six old DOS-style TEXT(70) fields into a single NOTE field to save space. I used UPDATE to set the NOTE field to have the values from the TEXT fields, with a CHAR(13) between each line to preserve the original format. I replaced the text fields on forms and reports with memo controls, and set the memo to Allow Returns.
My new NOTE field displayed and printed correctly. However, adding the NOTE field to what had previously been a fixed width table slowed down a view which used that table -- I presume because the rows were now variable width and harder for R:Base to scan. I tried converting the NOTE fields to VARCHAR, thinking that would return the rows to a fixed length and speed up the table scan in that view. My problem is that now I cannot get the memo control on my form to show the line ends as new lines. Instead, the R:Base LINEEND character (a caret) displays. I've tried the following: 1. Turning Allow Returns on and off in properties for that memo field. 2. Replacing all the carriage returns with carriage return + line feed (CHAR(13) + CHAR(10)) and also with just plain line feeds. 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. Does anyone have any guidance for me? -- Larry --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
