Paul and Larry
You guys are getting way over my head, it will take me a few days to work on
this.
I was thinking about a Temp Table, load the RTF data in there, do about a
dozer
SRPL for [Fname] [Address] ......, get that to the clipboard then paste to
the main
notes. One down side is I would have to change lots of code that does the
SRPL
on a Var.
I will search the archives for that thread
Thanks
Marc
--------------------------------------------------
From: "Paul InterlockInfo" <[email protected]>
Sent: Tuesday, July 14, 2009 5:14 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data
I think you still have Razzak copy to clipboard. I used a similar eep and
loaded a temp table with clipboard rows of clips. Unknown to the user as
they clicked it was grabbing (copy/pasting) info and loading it all into a
table for me. I then put it all together and made a var from that table
using all the rows that they could paste into a program outside of RBase.
It made all much happier people. A bit weird!
Sincerely,
Paul
You might recall a old post about me trying to parse multi clipboard
items.
That above was my answer.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of MikeB
Sent: Tuesday, July 14, 2009 5:59 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: combine two blocks of RTF formatted VARCHAR data
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" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
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" <[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
