David Smith

David Smith

  • NA
  • 2k
  • 0

Update syntax via where clause

Oct 11 2010 5:02 AM
I'm getting a syntax error in Update query via the where clause

                     sCommand = "UPDATE TABLE";
                     sCommand += "SET [Status] = '" + Row.StatusByOp + "' ";
                     sCommand += "WHERE [TABLE].[DataTime] = " + Row.DataTime+ ";";   //Missing operator on this line, not finding whats wrong with this line

Can someone assist me?

Answers (1)