Marc, Another non - issue in 7.6. All the Text manipulation functions work against VarChar in 7.6. Even if you can't deploy it system wide, you might want to use it at your desktop to help you over these speed bumps until you can deploy it.
Mike ----- Original Message ----- From: "Marc" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, July 24, 2008 11:59 AM Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Hit another snag on this. We look up text paragraphs and paste it into the Varchar field If the text has Lineends as blank lines it gets converted to the ^ and I loose the format. So even if I can convert the original date back to blank lines instead of ^, any time we all text from the lookup table we will get the same problem. It seems either I put up with this formatting issue to get Bold text or I stick with a 4k limit of a note field or I can't see the forest for the trees? Marc ----- Original Message ----- From: Emmitt Dove To: RBASE-L Mailing List Sent: Thursday, July 24, 2008 9:29 AM Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Can you then try replacing your lineend characters with (char(13)) using SRPL? Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Thursday, July 24, 2008 10:17 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Emmitt True but I was hoping to be able us make some text bold or use colors. If I use DB Memo on those you see all the font code.....unless I am missing something there? Thanks Marc ----- Original Message ----- From: Emmitt Dove To: RBASE-L Mailing List Sent: Thursday, July 24, 2008 8:58 AM Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Marc, VARCHAR will still work with DBMEMO fields. You don't need the Rich Text. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Thursday, July 24, 2008 9:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Note vs Varchar Db Memo vs DB Rich Edit Hi I have a note field for storing text and I use DB Memo's on my forms. This works great the ^ Lineend gets expanded to blank lines when you are in the forms as expected. Now, I need more room so I change the field from Note to Varchar then changed the form to use DB Rich edit. Now it seems that the ^ show up instead of blank lines when in the forms. Am I missing something or am I mixing up the data type and Rich Edit? Even if I use a DB Memo in the form to edit the Varchar text I still see ^^ instead of blank lines. I have Allow Returns checked. If I an in the Rich Edit and press Enter it puts in blank likes as I want, Those seem to stick but the old ^ Lineends are not converted or expanded to blank lines so to speak. Thanks Marc
