Bob What are the data types for each table (sevenft and MO_Qty)? They look different.
Dawn Hast [email protected] wrote on 12/04/2008 12:04:36 PM: > This must be my week for wierd issues, or my brain is fried. Not sure which. > > I want to update a column in a table by adding the value from a view > to the existing > column value. I.E. > Col X in table 1 = 5 > Col Y in table 2 = 3 > > I want to change the value for column X in table one to be (5 + 3) = > 8 as an example. > > The command I am using... > > Update BunkTable set SevenFt = (t1.SevenFt + t2.MO_Qty) + > from BunkTable t1, Totals_View t2 + > where t1.MO_Number = t2.MO_Number > > I get no error message and the returned response is : > Columns have been updated in 1 row(s) in BunkTable > > Yet the value for SevenFt in BunkTable never updates. For testing, > there is only one row > of data in BunkTable and one row in Totals_view. They are the same MO_Number. > > Actual screen shots... > > R>sel mo_number, sevenft from bunktable > mo_numbe sevenft > -------- ---------- > 18066 5 > > R>sel mo_number, MO_Qty from Totals_view > mo_numbe MO_Qty > -------- --------------- > 18066 21. > > R>update bunktable set sevenft = (t1.sevenft + t2.Mo_Qty) from > bunktable t1, totals_view t2 where t1.mo_number = t2.mo_number > Columns have been updated in 1 row(s) in BunkTable > > R>sel mo_number, sevenft from bunktable > mo_numbe sevenft > -------- ---------- > 18066 0 > > This value should be 26. > > Any thoughts? > > -Bob > > > -- > Thompson Technology Consultants > LaPorte, IN 46350 > 219-363-7441 > DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
