Where is the missing operator?

Printable View

Mar 7th, 2001, 01:43 PM
Ace

Hi Everyone,

I'm stuck on an UPDATE sql command. I keep getting an error message that says that i'm missing an operator. I am trying to get the HighPoint to subtract from the Amount in the text matrix where the item number in rsItemNumber equals the text matrix Itemnumber. What is wrong with what I am doing?

rsItemBalance.Open "UPDATE ItemBalance SET HighPoint = HighPoint - " & msgViewToday.TextMatrix(1, 0) & " WHERE ItemNumber = " & msgViewToday.TextMatrix(1, 1) & "", _
cnn, adOpenStatic, adLockOptimistic
Mar 7th, 2001, 01:52 PM
Achichincle

I think you have an extra set of quotes at the end of your statement.
Mar 7th, 2001, 01:53 PM
Bill Crawley

It looks ok, it might be easier if you declared a string and moved the update command the the string and look at what is in the string value, it may be clearer if you see what the update command actually says (i.e. your matrix values may be empty)