Mike
I downloaded a demo copy of 7.6 to a old slow computer to
test and it seems the Varchar field makes it rum much slower.
Maybe this weak computer is the problem or the larger amount
of data in Varchar?
I found a temp workaround by changing my report. I will use
this to keep the user happy then update later.
I keep going back and forth to 7.6 and 8.0. I do not think we will
hit the 2 gig limit but I think using Varchar takes up more space
even if the amount of text is the same?
Thanks
Marc
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, July 24, 2008 12:13 PM
Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit
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
