I think it was meant as

UPDATE blob_test SET
blob1 = ? FILTER FROM -2 TO 1,
blob2 = ? FILTER FROM -9 TO 1,
blob3 = ? FILTER FROM 7 TO 1;

Ivan

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, May 27, 2004 1:56 PM
Subject: Re: [firebird-support] BLOB Filter


> 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