> > > 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.

In that case, I was right about what exactly was "DSQL" and that
filters aren't supported in there. I got thrown off by the statement
from Paul... :
"The key to filters is the DSQL statement extension for blobs:
FILTER FROM sub_type TO subtype "

This apparently works fine in embedded SQL, but not in DSQL.

Back to square 1, Lester.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com