Searching text in datafield

ScaleRichView support and discussion (TRichView add-on for WYSIWYG editing)
Post Reply
alexandreq
Posts: 184
Joined: Wed Jan 18, 2012 6:22 pm

Searching text in datafield

Post by alexandreq » Tue Jun 25, 2019 6:40 pm

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
Site Admin
Posts: 14647
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Searching text in datafield

Post by Sergey Tkachenko » Wed Jun 26, 2019 8:00 am

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.

Post Reply