Subject | RE: [firebird-support] BLOB Filter |
---|---|
Author | Pierre Y. |
Post date | 2004-05-27T12:46:39Z |
> Would an update/insert be something like this then?Why not, that's sounds good :-)
>
> UPDATE...
> SET MyBlob = FILTER(:BlobParam FROM SUB_TYPE 0)
The only problem is that blobs a treated separately by the Firebird API. For
insert statements, you start by creating the blob, you get a BlobID and
finally you pass it through SQLParams to the ExecuteStatement API and for
select statements you start by executing the statement, fecth the blob ID
and finally get it within specific API calls.
Ideas ?
Pierre