Martijn

>>It was my understanding that a Blob Filter would process the data as it
>>is written into the Blob, compress it or encode it, and then uncompress
>>or unencode when the blob is read out.
>>
>>This is supposed to be a way to make sensitive data more secure, so that
>>without the filter, a copy of the database would be of little use.
>>
>>Have I got it wrong? Which is quite possible :)
>
> Well, last year in Fulda, Paul did a talk on an example BLOB-filter -
> however, it seems they can be used only in embedded SQL.
>
> What it comes down to, is that you need to _ask_ for data in a specific
> sub-type. Next, Firebird will use the BLOB filter to convert the data
> from the stored format to the asked-for format. However, when using
> plain SQL, you cannot do that.

This will probably show my ignorance :)
Is the implication here that one could use them with Stored Procedures?
SO the stored procedure could input and return the correct result?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services