Insert Image with SP

[vchapran]

I have a very complex stored procedure for insert/update. I've got a new request to add Image type field in this process. So far there was not any image data.
I do not have any problem with adding a new parameter to SQL Server SP, I have a problem with assigning the value to the new parameter in VB6.
Any sample code please.
Everything I found so far is an approach to create ADODB recordset and work with it.

Thank you
Vlad

[Pinky98]

why? is that not what you want to do? well you could also use an ADO command instead of a recordset if the procedure returns nothing.