Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
BLOB Field WHERE Clause |
Mon, Nov 24 2008 11:39 AM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |