Subject RE: [IBO] IB_RichEdit
Author Kaputnik
Depends on what you want to do.
If you mean to search the text of the blob with the rich-edit, yes. If
the methods to do that are not published (and I think they are
published) you can publish them manually in the source. TRichEdit offers
everything for you to search text.
If you mean to use the RichEdit in the sql-search-options like you can
do with memo's, you can, too.
You _can_ do SQL-Search in blobs subtype 1, and therefore in IB_Memo
easily (mind you, it is very slow).
A RichText has many tags enclosed in it and is normally saved in a blob
subtype 0 (binary)
If you save the rich-text as Blob Subtype 1, IB will be definitely able
to search in it based on plain search-criteria. Beware only of the tags.
If you build a small test-app and let both, an IB_Memo and an
IB_Rich-Text show the same blob subtype 1 and edit the field in the
rich-text, you will see after saving how the text is changed to contain
many cryptic characters and tags. Nethertheless, search will work, only
even slower as with memo's.


Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618


> -----Original Message-----
> From: Olafur Gudmundsson [mailto:olafurgu@...]
> Sent: Monday, November 19, 2001 8:34 PM
> To:
> Subject: [IBO] IB_RichEdit
> Hi. I'm would like to use a IB_RichEdit1 in my app. but is it
possible to
> make a Full text search on a blob text field using a IB_RichEdit1 to
> the data?
> Regards
> Olafur
> _
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> _
> - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to