Loading

Update syntax via where clause

David Smith

16y8.1k.NET

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

David Smith16y ago
Nevermind I was missing the # sign

sCommand += "WHERE [TABLE].[DataTime] = #" + Row.DataTime+ "#;";