I could likely use ColumnAttributes to make this easier.
I already work with blob filters for converting BLR to text.
This can be seen in the IB_SQL tool where you can see the BLR of stored
procedures in the browse database tool.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Martijn Tonies
> Sent: Friday, December 07, 2007 5:58 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Re: How to use blob filter
>
>
> > Seems that filters not used very often.
>
> It would be nicer if you could use blob filters in SQL, for example:
>
> select cast(myblobcolumn as subtype -2)
>
> and then the blobfilter from subtype <as stored in the column> to
> subtype -2 would be used.
>
> Or store it as -2 (zipped) and always retrieve it as "normal".
>
> But no, no such thing, hence, blob filters are much harder to use
> than they should be.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL,
> NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>