[RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data

[MikeB]

I am thinking that you might employ a "hidden" variable RichEdit control to 
hold your lookup value, then copy its' contents to clipboard, then on to the 
destination control.  Untested, but it seems like it should work.

----- Original Message ----- 
From: "MDRD" <mdrd...@sbcglobal.net>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Sent: Tuesday, July 14, 2009 5:31 PM
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data


Mike

I was thinking about the Clipboard too, but we do not want to physically 
see
the lookup text.  Just load it into a var or copy to the clipboard.

If Set Clipboard = Varchar in Table where.... would keep the format or
maybe if there was a RTFvarchar Variable that would keep the format and 
allowed
SRPL

Just thinking over my head again.

Thanks
Marc
If I stumble across something I will pass it on



--------------------------------------------------
From: "MikeB" <mbyer...@byerley.net>
Sent: Tuesday, July 14, 2009 3:47 PM
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data

I am pretty sure you can copy and paste from one Richedit to another and 
get the desired results (at least it works in wordpad which is built 
around the Microsoft RichEdit control which is the control we use in 
RBase, more or less).

----- Original Message ----- 
From: "MDRD" <mdrd...@sbcglobal.net>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Sent: Tuesday, July 14, 2009 4:37 PM
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data


Thanks Mike

I am sorry to hear that, it would really help what I am trying to do.

Maybe I can find a way around this?

Thanks again
Marc




--------------------------------------------------
From: "MikeB" <mbyer...@byerley.net>
Sent: Tuesday, July 14, 2009 3:18 PM
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR 
data

AFAIK, You can't do that with RTF.  It's not an RBase issue either.

If you will just write two files with one word of formatted text in 
each and save them, then open both of  the RTF files in a text editor 
like notepad and you will see why you can't combine them that way.

Rich text is just a markup language like HTML, so the effect is the 
same as concantenating two complete HTML files together which combines 
the description of two complete pages in one file, making it unreadable 
to the engine that parses the text.

----- Original Message ----- 
From: "MDRD" <mdrd...@sbcglobal.net>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Sent: Tuesday, July 14, 2009 2:45 PM
Subject: [RBASE-L] - combine two blocks of RTF formatted VARCHAR data


Hi

I am trying to look up a block of formatted Varchar data from one table 
then
Update a Varchar column in another table that has formatted text.

First I
Set Var VLookupText Varchar = Lookuptext In Table Where ...
The data is something like this
Instructions
Be sure to do this and that
Warning, do not play in traffic

Then
Set Var VcurrentText Varchar = CurrentText in CurrentTable Where ....
Set Var VNewText = (.VLookupText + .VcurrentText)
Update CurrentTable Set CurrentCol = .VNewText   Where .....

It seems that the formatted text turns into this in the Var and then 
the update fails.
{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil MS Sans 
Serif;}{\f1\fnil\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang1033\f0\fs16
\par


I am sure there is a simple solution and I am ready for egg on my face.
please make then scrambled, not over easy!
Thanks
Marc