1
Answer

Update syntax via where clause

David Smith

David Smith

14y
7.9k
1
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)