bloob

[Avacha]

Why doesn’t this line of code work?

Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN&quot
RsMath.MoveNext
Loop

PhotoBlobTable.photo_blob and RsMath.Fields(“photo_blob”) is blob
The Photo_blob value is not recognized, and I get this error:
Run-Time error ‘-2147217904(80040e10):’
No value given for one or more required parameters

Thamks for help.

 

[chiph]

What SQL type is photo_blob defined as?

Typically to update large binary objects in SQL Server, you need to let ADO know the size of the object before you start writing values to it. You would do this with an ADO Parameter, and not string concatenation like you're doing.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[Avacha]

This is access 2000