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" <[email protected]>
Sent: Tuesday, July 14, 2009 3:47 PM
To: "RBASE-L Mailing List" <[email protected]>
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" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
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" <[email protected]>
Sent: Tuesday, July 14, 2009 3:18 PM
To: "RBASE-L Mailing List" <[email protected]>
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" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
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
