Subject Re: [firebird-support] BLOB Filters
Author Helen Borrie
At 11:01 AM 13/05/2004 +0200, you wrote:

> > The key to filters is the DSQL statement extension for blobs:
> > FILTER FROM sub_type TO subtype
> > This isn't available in ISQL or procedures currently, although I suspect
>it could
> > be done.
>
>DSQL means? Embedded SQL?
>
>What is the exact name of the SQL we use in Delphi components?
It's DSQL - "dynamic SQL" - as contrasted with the stuff in embedded code
blocks that starts EXEC SQL - the following code is "static SQL" that gets
precompiled into macro calls by the gpre compiler.

For dynamic SQL you're supposed to be able to declare your blob filter to
the database and then use the FILTER FROM .. TO .. clause to output your
converted blob. I tried it every which way, using the predefined subtypes,
but it just kept telling me "Feature not supported" or something of that ilk.

So it's nice little task for someone to surface that out of the API and put
it into the DSQL language set.

/heLen