Helen,

> We *should* be able to use this syntax in DSQL:
>
> UPDATE blob_test
> SET blb_text = :zipped_file
> FILTER FROM -2 TO 1;
>
> I'd be interested to see whether it works for you. I've tried it using
> some of the system blob filters (unsuccessfully) but never with a custom
> filter...

I'll test as soon as possible.

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

I have never used esql but I think gpre just generates appropriate blob
parameter block before calling relevant API like isc_create_blob2 or
isc_open_blob2 so it don't need to send axtra sql statements to achieve blob
filtering.

Regards,
Pierre Y.