Subject | Re: [firebird-support] BLOB Filters |
---|---|
Author | Helen Borrie |
Post date | 2004-05-13T09:26:42Z |
At 11:01 AM 13/05/2004 +0200, you wrote:
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
> > The key to filters is the DSQL statement extension for blobs:It's DSQL - "dynamic SQL" - as contrasted with the stuff in embedded code
> > 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?
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