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 »

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: 17520
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Searching text in datafield

Post 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.
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