Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread BLOB Field WHERE Clause
Mon, Nov 24 2008 11:39 AMPermanent Link

Didier
I use Devexpress Scheduler, resource of events is stored in a Blob field, how can i set a SQL WHERE to filter from this Blob Field ?
Is it possible ? SELECT * From t_events Where f_resourceid = {I dont know the syntax for this blob field}

Thanks
Regards
Mon, Nov 24 2008 12:49 PMPermanent Link

"Eduardo [HPro]"
Didier

You can use TEXTSEARCH function

select * from YourTable where TextSearch('someword' in YourMemoField)

But

For performance reason you should define the memofield with full index (see
AlterTable, 10th parameter).

Eduardo

Mon, Nov 24 2008 1:24 PMPermanent Link

Didier
No, it's not working with BLOB fields only with Memos.

Thanks
Regards
Didier

"Eduardo [HPro]" <contato@hpro.com.br> wrote:

Didier

You can use TEXTSEARCH function

select * from YourTable where TextSearch('someword' in YourMemoField)

But

For performance reason you should define the memofield with full index (see
AlterTable, 10th parameter).

Eduardo
Tue, Nov 25 2008 6:30 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Didier,

<< I use Devexpress Scheduler, resource of events is stored in a Blob field,
how can i set a SQL WHERE to filter from this Blob Field ? Is it possible ?
SELECT * From t_events Where f_resourceid = {I dont know the syntax for this
blob field} >>

Probably the easiest way would be to define a custom function in the
TDBISAMEngine component that can read the BLOB, parse its contents, and
return the proper result.

You can find out more information on custom functions here:

http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=7&category=1&topic=8

under "Custom SQL and Filter Functions".

--
Tim Young
Elevate Software
www.elevatesoft.com

Image