Page 1 of 1

Searching text in datafield

Posted: Tue Jun 25, 2019 6:40 pm
by alexandreq

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%'


Re: Searching text in datafield

Posted: Wed Jun 26, 2019 8:00 am
by 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.
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.