Subject Re: [firebird-support] BLOB Filter
Author Martijn Tonies
Hi,

> > We *should* be able to use this syntax in DSQL:
> >
> > UPDATE blob_test
> > SET blb_text = :zipped_file
> > FILTER FROM -2 TO 1;

Naah, won't do. Think of multiple SETs and INSERTs as
well. A more generalized syntax would be better.

How about:

SET blb_text = FILTER(:zipped_file, -2, 1),

INSERT INTO ... VALUES (FILTER(:zipped_file, -2, 1), ...)

> > >I tested and that don't works. Maybe in PS/SQL ? Can this be a new
> > "feature"
> > >for furter versions of Firebird 1.5 ?
> >
> > If it doesn't work already, then I suspect it would be a matter of
> > activating it in DSQL somehow, since the engine already knows how to do
it
> > for ESQL.
>

With regards,

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