Re: Searching in BLOB field that created by DBRichView!

Author

Message

Sergey Tkachenko

Posted: 04/08/2003 10:42:50

I am not sure how WinOrganizer searches for text.

It may be pre-create index for full text search (extracting text from each

field, indexing it, then searching in this index).

It may be searches records one-by-one, loading it in RichView and searching

text in it.

In both these cases Query is not used.

Another possibility - saving documents as RTF in db fields (some db search

engines may be able to search in RTF), but this is inefficient, oversized

fields, formatting-lossy.

> I know that DBRichView sotre files in Database in BLOB Field.

> As I know there is no way to search in a BLOB field using Query.

> Are you know a way to search in BLOB field that created by TDBRichView.

> There are a program named "WinOrganizer" It use TRichView an it still can

> search in content. I dont know HOW? and Is it use query or not?

> But I want to know is there a way to search using Query in BLOB field that

> DBRichView created!

> Otherwise, are you know a way to search in such field?

> Regards