blob value Access 2000

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

 

[MakeItSo]

;-)
Guess you've forgotten the equals sign =

UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & "

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[Avacha]

Thanks but I missed "=" sign when I did copy.

 

[MakeItSo]

The I guess it's the quotes:
Are photo_blob and SSN text or numerical?

If text, then

"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob='" & RsMath.Fields(“photo_blob”) & "' where PhotoBlobTable.ssn= '" & RsMath.Fields("SSN&quot & "'"

 

[Avacha]

photo_blob is binary (OLE object) and SSN is numerical.

 

[MakeItSo]

Gulp

in that case:
a) ignore my last post
b) Guess I must bow down and silently watch this thread, as I have never worked with OLE Objects in tables.

Hope Tony or any other of the wiz's reads this thread and hops in.

Sorry, that i can't provide help on that issue.
MakeItSo

 

[Avacha]

Thank you anyway.