Thanks Dennis, I tried an index on Mo_Number and placing the table order as you have it below. Niether option worked. (This is still a 7.5 version system) I do get the "Columns have been updated" verification response, but the column does not change.
Oh well, on to other things. -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: Dennis McGrath <[EMAIL PROTECTED]> What I am saying is use this statement, it puts the view first. update bunktable set sevenft = (t1.sevenft + t2.Mo_Qty) from totals_view t2, bunktable t1 totals_view t2 where t1.mo_number = t2.mo_number From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, December 04, 2008 12:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Update command question Dennis, The second table in the statement is actually a single table view that sums the MO_Qty column. I do not have an index on the table. I will give this a try later in the day. Thanks! -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: Dennis McGrath <[EMAIL PROTECTED]> I have not run into that problem lately if the second table is indexed. Dennis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: Thursday, December 04, 2008 11:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Update command question Dennis, That's interesting. Once upon a time, you had to have the table that was being updated list first, in the list of tables after FROM, or the update could have unexpected results. Bill On Thu, Dec 4, 2008 at 12:16 PM, Dennis McGrath <[EMAIL PROTECTED]> wrote: Also, put the view first in the list and make sure bunktable.mo_number is indexed, even if it is a temp table. Putting the view first makes the query much faster. Dennis McGrath From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: Thursday, December 04, 2008 11:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Update command question Bob, It looks like your datatypes don't quite match. You could try ((1.0 * t1.sevenft) + t2.Mo_Qty) Bill On Thu, Dec 4, 2008 at 12:11 PM, Bill Downall <[EMAIL PROTECTED]> wrote: Bob, Do you get what you expect when you do this: SELECT t1.sevenft, t2.Mo_Qty, (t1.sevenft + t2.Mo_Qty) + FROM bunktable t1, totals_view t2 + WHERE t1.mo_number = t2.mo_number Bill On Thu, Dec 4, 2008 at 12:04 PM, <[EMAIL PROTECTED]> wrote: 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
