Hi Bill, Hmm. I've always used a table alias for the updated table in a multi-table UPDATE without a problem. Indeed, the final example in (9.1) help for the UPDATE command is:
UPDATE inventory SET onhand = (T1.onhand - T2.totalsold) + FROM inventory T1, orders_view T2 + WHERE T1.partid = T2.partid Does this have something to do with the VARCHAR? Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, August 31, 2012 12:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Update problem Tom, Do not use a table alias (t1) for the table you are updating, use the full name update CommonCode + set CCData = t2.CCData, + CCModified = t2.CCModified + from CommonCode, tmpCode t2 + where CommonCode.CCName = t2.CCName + and CommonCode.CCModified < t2.CCModified Bill On Fri, Aug 31, 2012 at 11:44 AM, TOM HART <[email protected]> wrote: I get an I/O error when I try to run: update CommonCode set CCData = t2.CCData,CCModified = t2.CCModified+ from CommonCode t1, tmpCode t2 where t1.CCName = t2.CCName+ and t1.CCModified lt t2.CCModified I am trying to update a code table if the modification date changes CCData is the code=varchar CCModified is DateTime stamp which I want use to update code
