ppDBRichText repeating bad RTF Blob over and over

rbuser

Hi, I believe our customer database somehow got bad rtf codes in some
BLOB field note in their database. Now when they run a report we created,
all notes bound to a ppDBRichText control up to the offender are ok, but
after the offender, all fields display fine except for the note field, which
displays the bad note for the rest of the report. If the offending notes are
deleted, all displays fine.
Is there a way to just ignore the bad notes, but still display the good
ones? I ask because there could be a good many of these bad notes and I do
not know how to identify them (except by running the report and looking for
repeats). I tried making a calculated field and mapping the Note.AsString to
it, but I get the same problem. I was hoping an illegal char was there and
the .AsString would filter it out.
Do you have any further ideas? Thanks.

Steve

digitalmetaphors

What is wrong in the RTF? Can you parse the rtf to see what tag is causing
it? Is there no end page tag? Can you "clean" the rtf in a preprocessor
before the report loads the blob to the rtf? You can use the DB rich text
control's OnGetRichText event to do this. See the help file for information
on using this event.


Cheers,

Jim Bennett
Digital Metaphors Corp.

rbuser

Hi, I found the offending tag to be:

\protect\f1\fs20

Do you know what this tag is? When I remove it the notes display correctly.
Some type of copy/read-only protection?

digitalmetaphors

It must be some kind of protected font that your users are using in their
machines on the data entry side of the application. Is that font installed
on the client's machine where the report is being run?


Cheers,

Jim Bennett
Digital Metaphors Corp.