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
