sSQL = “update ““BidItemDetailT”” “&_
“set “&_
“”“TypeRec”” = (select ““TypeRec”” from ““ResorceT”” where ““Resorce_ID”” = “”“BidItemDetailT””.”“Resorce_ID””)," &_
“”“Quantity”" = “& iQty &” " & _
“”“where ““Resorce_ID”” = ““BidItemDetailT””.”“Resorce_ID”" and ““BidItemDetailT””."“Price”" is null;"
the above statement works, but when i try to add another field, sUnits it will not work. I have tried several syntax changes none work
the following is what i am trying to do
sSQL = “update ““BidItemDetailT”” “&_
“set “&_
“”“TypeRec”” = (select ““TypeRec”” from ““ResorceT”” where ““Resorce_ID”” = “”“BidItemDetailT””.”“Resorce_ID””)," &_
“”“Quantity”" = “& iQty &”, " & _
“”“Units”" = “& sUnits &” " & _
“”“where ““Resorce_ID”” = ““BidItemDetailT””.”“Resorce_ID”" and ““BidItemDetailT””."“Price”" is null;"
the comma in the quantity is the problem. How should it be handled?
Also, is there a way to send attachments? I had to put all the quotation marks in manually so if i missed one that’s not what the problem is.