UpdateMulti question

Posts   
 
    
nottinbe
User
Posts: 46
Joined: 15-Mar-2007
# Posted on: 05-Jul-2007 15:52:54   

How can I use UpdateMulti to increase a column's value for each row by a given amount? I understand how to use it to set each row's value to a constant, but I don't see how to use it to assign a value that references another value within the row.

Such as:

UPDATE [Order] SET Total = Total + 10 WHERE Something > 5

Thanks, Brian

nottinbe
User
Posts: 46
Joined: 15-Mar-2007
# Posted on: 05-Jul-2007 16:07:33   

Sorry, feel free to delete this. Its been answered before, several times.

(http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3853&HighLight=1 for one).