At 04:32 PM 26/05/2004 +0200, you wrote:

>Is there a way to ask the engine to use filter(s) while executing this
>statement :
>
>UPDATE blob_test SET
> BLB_TEXT = BLB_ZIP;
>
>i.e to decompress the contents of BLB_ZIP before storing the text as
>uncompressed datas into blb_text.

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

/heLen