i am using vb6 to write to an sql 2008 table. The table contains the field Description with is an image datatype.
my recordset is called rPurchaseOrder, so my code is something like this
DIM S AS STRING
S = "tHE QUICK BROWN FOX JUMPS OVER THE LAZY DOG"
With rPurchaseOrder
![Description] = S
!OtherField = ETC ETC ETC
.updatebatch
end with
When i am trying to update the batch I am getting a erorr becasue S is a string and i am posting it into an Image field. is there a way of converting s to a binary value, as i think this is what I need to do.