Subject Re: [firebird-support] Blob External Filter
Author Regina Phandu
> From what I've understood from a presentation by Paul at the Fulda Firebird
> Conference, BLOB filters are hard to write if you follow the docs - and,
> even
> worse, impossible to use if you don't use Embedded SQL.

Are there any examples of writing filters using Embedded SQL?

In my understanding, external filters are defined according to the datatypes
we plan to translate, and are written in either in C or Delphi and should be
defined as a dynamic library, recognized by (defined against) the database.

Thus, i can't see where Embedded SQL would fit in. Do you mean, that my app
should use Embedded SQL to support Blob data operations (insert, update,
delete and select) ? Fortunately i have develop an abstraction layer (using
APIs) to do those operations and it works fine for standard blob subtypes.
Problem is, it doesn't work against non-standard (own-defined) subtype Blobs
(sometimes even causing the server to crash !). My debugging have come to
the conclusion that the filters are not working the way they are supposed to.

Are there any other filter samples beside the one provided here by ibphoenix?
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1063110103:68383&page=ibp_blo
b_filter