Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread BLOB update in SQL
Thu, Apr 5 2007 7:04 AMPermanent Link

"Harry de Boer"
LS,

EDB 1.02

I want to load an image in a BLOB field.
Can I (if so how) update a BLOB column in SQL?

Regards, Harry


Thu, Apr 5 2007 12:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< I want to load an image in a BLOB field. Can I (if so how) update a BLOB
column in SQL? >>

In an SP, or just via the client application ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Apr 5 2007 1:28 PMPermanent Link

"Harry de Boer"
Tim,

In an SP.

Regards, Harry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:CC97E5B9-62D6-4E30-AE64-5BFE1A22D61A@news.elevatesoft.com...
> Harry,
>
> << I want to load an image in a BLOB field. Can I (if so how) update a
BLOB
> column in SQL? >>
>
> In an SP, or just via the client application ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Fri, Apr 6 2007 3:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< In an SP. >>

That's a little more difficult since SP's don't currently provide for any
file-system functionality.  The two alternatives are to 1) pass the BLOB in
as a parameter, and load it from the client or 2) use an external module as
a function that returns a BLOB for providing the file system loading
functionality.

If you need some more information on 2), just let me know.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image