bloob DB Access

[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.

 

[Glasgow]

Does RsMath map to another table in the database called, for example, MathTable. If so could you not do it in one line:

CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=(SELECT MathTable.photo_blob FROM MathTable
where PhotoBlobTable.ssn= MathTable.ssn)"

The SQL syntax is probably not quite right but do you get my gist?