Searching text in datafield

[alexandreq]

Hello

I have a trichview linked with a dbfield, is it possible to do a search in my dbfield for a expression, word, something like:

select idtext from table where field like '%house of sun%'

thanks
regards

[Sergey Tkachenko]

Sorry, no.
If you have RVF field, you have the following options to search:

1) Create one more field, a plain text. When saving RVF field, save a copy of document as a plain text in another field.
Then you can use SQL queries or other standard tools to search in this plain text.
or
2) Load content of RVF field in TRichView one by one, and search in TRichView.

If you need to know how to implement (1) or (2), I can create an example.