Subject | Re: [firebird-support] BLOB Filter |
---|---|
Author | Martijn Tonies |
Post date | 2004-05-27T11:56:52Z |
Hi,
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), ...)
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> > We *should* be able to use this syntax in DSQL:Naah, won't do. Think of multiple SETs and INSERTs as
> >
> > UPDATE blob_test
> > SET blb_text = :zipped_file
> > FILTER FROM -2 TO 1;
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 newit
> > "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
> > for ESQL.With regards,
>
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com